Viewing 15 posts - 16 through 30 (of 45 total)
What about running SQL Server 7 on Windows 2003? IS this supported and/or possible?
May 24, 2004 at 8:26 am
How about seting up a file has a linked server using a flat text file ODBC driver? OR something along those lines. Treat the file has a single column table and...
April 8, 2004 at 1:24 pm
Here is the command that ended up working for me. I put it all on one line in bat file. I was even able to email...
April 6, 2004 at 9:04 am
I have a very close relationship with my domain admins, so they have given me account administration rights. I only create groups in my OU's and edit group membership. We...
February 16, 2004 at 2:33 pm
This raises a good question. I hear less and less about using Local groups and see more and more people assigning access to local resources directly to global security groups....
February 16, 2004 at 10:24 am
If you haven't setup security on your access database the login is admin and the password is blank. Thoses are the defaults for access.
February 16, 2004 at 9:21 am
Why so you need to use ADO. The pass-through query is sent to SQL Server has is. Just get the SQL Syntax working in Query Analyzer and then paste...
February 11, 2004 at 11:00 am
You can also enter the UNC in the maintenance plan wizard. You have to type it in or paste it, you can not browse for the UNC folder. I...
January 22, 2004 at 8:22 am
Am I correct that you are trying to map the SQL server service account, the SQL agent service account, and the proxy account; all to the same domain login? I...
December 18, 2003 at 8:43 am
The Microsoft web site for MSDE lists several 3rd party admin tools for MSDE 2000. Teratrax has a free eval download.
December 2, 2003 at 4:00 pm
I would install SP4 and then install the hotfix patch form Microsoft Security Bulletin MS03-031. That will bring you to SQL Server 7.00.1094 and protect you from the most viruses...
November 24, 2003 at 9:14 am
Run the command "select @@version" in Query Analizer. You should see "7.00.1094" to be on the latest, safest version of SQL Server 7.
"7.00.1063" means you have Service Pack 4....
November 24, 2003 at 9:02 am
We use Latin1_General_BIN. Watch out if you use temp tables in stored procedure are your system tables (tempdb) have a different collation sequence.
November 17, 2003 at 2:09 pm
Check the ownership of the jobs that are created when you scheduled the DTS Packages. Look at the job history for error messages.
October 30, 2003 at 3:08 pm
If your recovery model is already set to SIMPLE then I would stay with the insert command and do your transformations in the select statement. If you need to empty...
October 30, 2003 at 2:50 pm
Viewing 15 posts - 16 through 30 (of 45 total)