Answer Questions

• citegestion dynamically switching databases in a script

  I've got a situation where I need to execute portions of a script against every database on a given instance. I don't know the name of all the databases beforehand so I need to scroll through them all and call the "use" command appropriately. I need the correct syntax, the following won't work: DECLARE DBS CURSOR FOR SELECT dbname FROM #helpdb ORDER BY dbname OPEN DBS FETCH NEXT FROM DBS INTO @dbname WHILE @@FETCH_STAT ...Show All

• hegel Microsoft best practices for implementing windows authentication for sql server 2005

  Microsoft recommends using Windows authentication instead of SQL Server authentication in SQL Server 2005 for improved security. What are the Microsoft best practices for implementing this Will be helpful if someone also provides some links that talks about this....              Hi Laurentiu, Thanks for the reply. Can you suggest me wat considerati ...Show All

• ConnollyG SSIS FTP TASK (sending file appends underscore to front of file)

  I'm attempting to use the FTP task to send a .txt file to OPEN VMS. The file is successfully PUT, but an underscore is appended to the front of the file. In SQL 2000 DTS, I was using a cmd file to conduct the FTP and this worked properly. I wanted to eliminate the cmd file in SQL 2005 SSIS. original file: DELETEME.TXT when put on VMS: _DELETEME.TXT ...Show All

• Manojas Remote messages not working – message vanishes

  I need some assistance with getting service broker to work across servers.   I have 2 separate servers and I am trying to send a message from one server to the other.   No error is generated when sending the message and I get no records in the transmission queue of the sending server, however the message does not arrive on the receiving server.   Where is the message going     Here is the code I use to create ...Show All

• BriceIt Getting Error 1935 when trying to install SQLXML 3 SP3

  I have a Windows 2003 Server SP1. I have SQL 2000 Server SP4 running on it. I am trying to instal SQL XML 3 SP3 on this server. But the installation aborts midway giving an error.I got the following in the event log.  Product: SQLXML 3.0 SP3 -- Error 1935. An error occured during the installation of assembly component {303994BA-6487-47AE-AF1D-7AF6088EEBDB}. HRESULT: 0x80070002. assembly interface: IAssemblyCacheItem, function: Commit, asse ...Show All

• Sperin Email tasks fail after an unsuccessful SQL 2005 installation

  I tried installing SQL 2005 Dev Edition on my Win 2000 Professional machine. That failed. But now I cannot send out emails or even open a simple Email task from DTS. This is something that worked perfectly fine before I attempted the SQL 2005 installation. It seems that the SQL 2005 installation somehow messed up the the MAPI profile. The exact error message that I get when trying to execute or open a Email task in DTS is: CAnnot load MAPI Inter ...Show All

• claudioe Sql Server Express Database login problem

  Hi! I'm using Sql server 2005 Express, and now i have a login problem. I want to create a user for my database in Sql Server Authentication mode, that when others that they don't know sa password and login in windows authentication mode can't see or can't access my database. I did these steps : 1. I loged in to sql server in 'sql server authentication' mode and with strong sa password 2. I went Security \ Logins and created new login w ...Show All

• drainey SQL Server Reporting Services - components

  I'm running SQL Server 2005 Express Edition and Visual Studio 2005 Web Developer Express. How do I get access to the SQLServer Reporting services components so I can get aquainted with the tools john welte ...Show All

• Washington Public role and explicit rights

  I gave a developer rights to the Public role on a SQL Server 2000 database.  The Public role only has explicitly set select rights to the system tables and one user table.  There are no other explicit rights set.  The developer was able to open a table that had no rights set in enterprise manager and change data.  Is this possible What are are the rights in Public if an object doesn't have them explicitly set Tha ...Show All

• PK_Sean Items that are filled in

  Hello, AND b.fired_day LIKE (CASE WHEN @type = 'b' THEN '%' WHEN @type= 'l' THEN '-1' WHEN @type= 'o' THEN '0' END) I want the following thing: When type= b, then show everything When type=l, then show the items that aren't filled in When type=o, then show the items that are filled in What's wrong with my code (b.fired_day is a date) I am assuming the '-1' and '0' clauses are coming from ACCE ...Show All

• Waitcursor Query Paging

  let's suppose that we have a table entitled "tab1" which has more than 1000 rows and about 10 columns so in SQL 2000, if I do this query: SELECT * FROM tab1 the result will be displaying all the rows from the begining. and my teacher told me that there's a new option in SQL 2005 which is you can display the result of the query in a page mode. so can anyone tell me how can I do so for this query: SELECT * FROM tab1 ...Show All

• jagadisha FTP Task issue

  The FTP Task I've created fails. It appears to be making the connection initially behind a firewall, but it suddenly switches from port 21 to port 3397. Anyone experience this issue Since my firewall is restricting the connection to just port 21, I can't make a permanent connection. FTP use 2 ports for it work - one for control connection (21) and one for data connection (any other, 3397 in your case, but may ...Show All

• Smurble how to automate cleaning the data in repldata folder

  hi everyone, can any one suggest me how to clean the 'REPLDATA' folder created during snapshot replication. i want to automate the process. can anyone suggest any undocumented sp like 'sp_MSDelete_publisherdb_trans' thanks i want to clean the expired snapshots, we cando this manually. but i want to automate the process. i got both trans and snapshot. hi R ...Show All

• Revlisoft I want the user to only see the History Tab and nothing else

  Dear Anyone, Is it possible to configure the security of a report to only allow the user to see the history tab and not the properties, subcription and view tab and in addition, only view the snapshot reports and not the actual report itself Thanks, Joseph Joseph, This is not possible with the current security granularity. You can apply "Manage Report History" which gives the user the rights to view history ...Show All

• SusanC Single connection with SQL 7.0 Gateway

  Our company is using a development tool named eDeveloper. This tool comes with a gateway for SQL 7.0 Since we upgraded to SQL 2005 the connection is limited to a single connection Are there any setting that related to the number or type of connetctions for backward compatibility (I have no problem openning multiple connection using VS 2005) ...Show All