Viewing 15 posts - 1,681 through 1,695 (of 2,496 total)
There is a sp in SqlServerFindBuild that does a bulk export of DTS packages. The sp outputs to structured storage files, but it is easy to tweak the output...
April 9, 2008 at 3:22 am
There has been a lot of incorrect information posted in this thread about /3GB and /PAE!
Colin Leversuch-Roberts spends his (working) life fixing SQL performance issues. If you want to...
April 9, 2008 at 3:14 am
There are a number of scripts on the web that can do a bulk export of DTS packages. Most of them (including those in SqlServerFineBuild) are aimed at transferring...
April 9, 2008 at 2:57 am
Just for intrerest, why do you want to limit the number of connections? SQL Server can easily cope with hundreds of simultaneous connections.
April 9, 2008 at 2:53 am
What are your objectives in doing this work?
If you simply want to get naming conventions and coding standards to comply with current site requirements, IMHO this is a total waste...
April 9, 2008 at 2:51 am
Almost certainly the account needs the 'logon as a batch job' right.
April 9, 2008 at 2:31 am
Also take a look at a TechNet Plus Direct subscription. This gives you all the MS server and office software for personal use. No time restrictions. It...
April 8, 2008 at 3:03 am
I agree with K Brian Kelly. The most likely cause of the error message is that SQL Server cannot verify that the account exists. Check that the domain...
April 8, 2008 at 2:40 am
oops, I overstated it a bit...
The ISO 15408 standard covering what is called Common Criteria was ratified in 1999, and revised in 2005. The drive to create...
April 4, 2008 at 6:22 am
If you want a SQL Server 2005 cluster it has to be installed as a cluster. You cannot upgrade a non-clustered instance to clustered.
You have a lot of risk...
April 4, 2008 at 2:55 am
Open the Windows Service Control applet and navigate to the SQL Server service. Look at the Recovery tab, and you see you can specify a script to run if...
April 3, 2008 at 3:09 am
Don't even try this!
None of the system databases can be moved from SQL Server 2000 to SQL Server 2005. You need to script out all user objects...
April 3, 2008 at 3:05 am
Be aware that the concept of 'C2 Auditing' is obsolete. The C2 level was based on the old US DOD 'Trusted Computer System Evaluation Criteria', that became obsolete almost...
April 3, 2008 at 2:56 am
You need to do inegrity checks, but there are pros and cons for including them in the backup process. You need to decide what is best for your site.
Pros...
1)...
April 2, 2008 at 3:52 am
It is possible to extract the text from a Word document, then import the text into a SQL table and create a Full Text index on it. This can...
April 2, 2008 at 2:30 am
Viewing 15 posts - 1,681 through 1,695 (of 2,496 total)