Viewing 15 posts - 2,026 through 2,040 (of 2,496 total)
Look in the system Environment variable PROCESSOR_ARCHITECTURE.
June 13, 2007 at 2:53 am
Once you have got your Logins known to SQL, you can detach your user databases from SQL 2000 and attach to SQL 2005 (or restore a backup to SQL 2005) and...
June 12, 2007 at 2:24 am
I think you need to separate the issues of transferring SQL logins from the issues of database users.
If you send me your email address, I will send you our proc...
June 11, 2007 at 6:12 am
There have been many tools such as LINQ in the past, that purport to make life easier for developers by avoiding the 'pain' of coding SQL. Most of these have...
June 11, 2007 at 6:04 am
If you installed SQL 2005 on to a W2003 server, .Net 1.1 is already there. The SQL 2005 install will install .Net 2.0 if it is not already on the...
June 11, 2007 at 5:41 am
You should only consider a in-place upgrade from SQL 2000 to SQL 2005 if all other options are impossible.
The result of an in-place upgrade is messy. You have a...
June 11, 2007 at 5:34 am
You have to specify the port number after installation completes, using SAC or other tools.
You can change the file location on the Feature screen. Highlight a component and click Browse.
Every...
June 1, 2007 at 3:57 am
My advice is leave master, mssqlsystemresource and distmdl files in their default locations. I have had no problems in moving model, msdb and tempdb.
SP2 changes the way SQL Server deals...
June 1, 2007 at 3:51 am
My advice is leave master.mdf, the mssqlsystemresource files and distmdl files in the default location.
Our SQL2005 SP1 standard was to move all these files to specific locations, with the ldf...
June 1, 2007 at 3:25 am
If your packages have custom tasks you will get this message. If it is a custom task problem your MSDB is probably OK, all you need to do is register...
June 1, 2007 at 3:12 am
I agree with 50% of what SQLBill says on this.
If you use a maintenance plan to reindex, you will see a large amount of free space at the end...
May 31, 2007 at 4:13 am
You should convert your Dev databases before your Test, and Test before Production. It is a few years since we converted from SQL7/NT4 to SQL2000/W2003, and there were a few...
May 31, 2007 at 3:54 am
We store all our critical data on HDS SANs, one in GB and one in US, and these use async replication and are fully integrated into our DR plan.
On our...
May 31, 2007 at 3:32 am
Our standard build includes SP2 and hotfix rollup 3152. Agent runs fine here.
May 30, 2007 at 9:24 am
If you are using vbscript to generate your file deletes, then Google for information about the FilesystemObject. This has properties that can give you the creation date of each file,...
May 25, 2007 at 3:40 am
Viewing 15 posts - 2,026 through 2,040 (of 2,496 total)