I created a domain user account to run my SQL Server 2000 services under, and I noticed that account got added to the SysAdmin role. Why was this...
I just performed a clean installation of SQL Server 2000 with SP3a so I am running version 8.00.760. What hotfix level do you recommend I install up...
I have 4 tables that I need to import from Oracle. I've used DTS to import the raw data from my other tables, but DTS won't work on these 4 because...
Ok, it's been while, but how do you guys pad a date column with zeros. For example I select DOB and it returns: 2/6/1972 I want it to return:...
I need to do the following and would like to hear some recommendations on how to do it: 1. Write the results of a query (via a stored procedure) to...
Is it more efficient to store your MDF and LDF on the same server as your SQL Server installation or move them to a seperate server? ---------- T...
Hi guys, We currently have 9 different servers running SQL Server 6.5, 7.0, and 2000. When I upgrade the older versions, I would like to...
Where in SQL Server 7 can I determine how many CAL licenses were purchased or if it is a processor license? Thanks... [8D] ---------- T Kelley MS,...
I have a couple of questions: 1. Is there a way to write to the NT Event Log within an SQL Server 7 stored procedure? 2. Is there a way to dump...
My ASP apps on Server1 quit working when I connect to SQL Server on Server 2 since I installed the latest Security Patch (Cumulative Patch for...
I'm writing a web-based internal app that I would like to set up so that after a record is created a user presses a button that kicks off a stored...
Can somebody describe the difference between VARCHAR and NVARCHAR? I know the latter stores data in Unicode (max lenght 4000) and the other doesn't,...
I'm running SQL 6.5 on an NT box that is severly fragmented, my datafile is almost 11 GB and the drive stores over 200 GB of picture files (this is a...
In SQLServer 2000 I want to send emails when my tasks complete. I understand that Outlook 2000 needs to be installed for SQLMail to work. Is...
Is there a way in SQL Server 6.5 to send a NetSend message if a Scheduled Task fails? I see where I create an Operator and send an email or page....
Here at work, we have an extremely large SQL 6.5 database, and we perform several scheduled tasks. I believe this is filling up my msdb database...
I do a massive amount of web development in Active Server Pages, and I use a DSN-Less connection to connect to my databases. This requires that I...
Could some of you guys/gals send me a recommended drive configuration for running SQL Server 2000? Here is what I have in mind for a new system we...
I know Microsoft recommends not changing the memory and processor configuration settings for SQL Server, but our network engineering supervisor...
Does anyone have any white papers or links comparing SQL Server 2000 and Oracle 9i? I'm looking for some good papers from independent sources other...
Separate names with a comma.
