Search results for query: *

SQL Server 2000 SP 4. I have three logins on SQL Server for this server. 1. Domain account with System Administrator role. 2. Domain account with db_datareader on one database 3. SQL Server account with db_datareader on one database. Testing method. Open Query Analyzer on my desktop and log...

I am doing research on SQL Server 2005 and have not yet found any definitive answers to the question: Should the separate components/services (Database, Analysis, Reporting, and SSIS) be on the same server or on separate servers. While I continue to research this and try to find appropriate...

SQL Server 2000 SP4. I have a developer who is trying to modify a stored procedure on the development server. He gets the error: We aren't going to give him sysadmin role permissions for any reason, but especially not just so he can work on one stored proc. I have searched for that error...

I am having occurances of a server running out of disk space because SQLDiag.txt grew and took up all the disk. It will run amok until all the disk space is gone. I'm trying to record the when, where, etc. so I can find out if there is any consistency with the occurances. I haven't been able...

-SQL Server 2005 Enterprise Edition -Windows 2003 Enterprise Edition -Cluster (active/passive) -AWE is set, results of sp_configure show AWE is 0,1,1,1 -Pages are locked in memory for the SQL Server service account -8 Procs total of 16 GB available -Small database (2.6 GB) We monitored the...

I have a developer that is fighting going to SSIS, they are more comfortable with DTS and I have to support it. They have a DTS package that gets data from an Access database, transforms it, and puts it into a SQL Server 2005 database. This package works fine for them when they execute it. I...

If you haven't heard by now, Microsoft has issued a new version of Service Pack 2. The new date for the SP is March 6th 2007. You CANNOT install the new version if the old one is already installed. But there is a fix....here is the information from Microsoft. Reference...

Background: I administer both SQL Server 2000 and 2005 servers. We have DTS packages running on both. Recently, I had an issue with a DTS package on a 2005 system. I couldn't open it and view the package. The solution was to install SQL Server 2005 SP1 on my desktop to update the client...

I have a tasking. Specific data needs to be encrypted to 256 or better. I'm specifically concerned about the data in SQL Server databases, but a solution that would work for several db's (Oracle, etc) would be best. Does anyone know of a product that encrypts data on the database? I need to...

I've run into a curiosity. While creating a script to correlate some data, I was trying to use MIN() and MAX() on a identity column based on values in a datetime column. Using MAX(), I got the results back in six seconds (00:00:06). Using MIN(), I got the results back in 8 minutes 43 seconds...

I am finally working with using OSQL and came across a problem I can't solve. The query runs fine and returns what I expect it to do. However, I am having it output the results to a .txt file and that's where the problem is. I'm having problems with formatting the output. My results look like...

SQL Server 2000 SP3a We use a vendor created database. We were running it on a Windows 2000 box with the latest service packs and everything was running fine. Saturday, we migrated to a Windows Server 2003 SP1 system as our Win2000 box was really old. Our database immediately had problems. Our...

I have to do some work with archived data which requires me to restore the data to the same server our current data is on. That means that I will have two databases with the same name. Here is what I plan on doing: 1. create a new instance (\\servername\Archive) 2. create a new folder on the...

SQL Server 2000 I have a database with 9 months worth of data and am trying to get it down to 6 months worth of data. The database was created by a third-party application and I have to use a 'purge' command they supply. I'm trying to find the quickest way to delete a set amount of data (not...

Our main database is part of a vendor product. Back when SQL Server SP3 came out, I applied it. When SP3a came out, Microsoft said there was no need to apply it if you have SP3 applied. Now the vendor (who doesn't support SP4 yet) is stating that we need to apply SP3a for their product to work...

The Professional Association for SQL Server conference is being held in Texas this year (September 26-30). (www.sqlpass.org) My company is sending me....is anyone else going? -SQLBill Posting advice: FAQ481-4875

Symantec (Backup Exec's new owner) has a warning out about BE along with the Remote Agent for Windows and Remote Agent for Linux/Unix. There is a vulnerability that can allow an unauthorized remote attacker to download arbitrary files. Check out the Symantec web site for the patches. (For 8.6...

SQL Server 2000 SP3 I currently have a 200+ GB database with 9 months of data. The more data added to the database, the slower it gets (obviously). I currently have permission to 'trim' the database to 6 months of data. But I am working on a 'better' solution and need some advice/suggestions...

My server is dying...it's getting obsolete and it doesn't have enough umph. We currently have SQL Server 2000 Enterprise Edition on Windows Advanced Server 2000. We are installing SQL Server 2000 EE on a Windows 2003 Adv Server. I have the user database files and the TEMPDB on a SAN system...

I am running a stored procedure via a job. My end-user would like the output as a Comma Separated Value (CSV) report. Running this as a job doesn't produce that type of output (I can do it via Query Analyzer, but not via a job). I have heard that BCP or DTS can do this and am reading up on...