Viewing 15 posts - 676 through 690 (of 1,271 total)
Are you still granting permissions on an object level? In SQL 2000, to grant someone execute on all procedures, you had to grant it for every procedure, but in SQL...
July 13, 2007 at 8:40 am
That is incorrect. Database snapshots are only available in the Enterprise and Developer Editions.
You have a lot of options available to you: snapshot replication, log shipping, full backup & restore.
June 28, 2007 at 9:23 am
In which databases are you running it? What was the duration of the query in the SQL trace?
SSMS is running the query on every database. How many databases are on...
June 28, 2007 at 9:09 am
Books Online very clearly states:
The target recovery point must be contained in a transaction log backup.
See this topic in Books Online for the above quote: restoring databases [SQL...
June 26, 2007 at 10:22 am
The /Z switch is only for encrypting the command line parameters, such as user ID and password, that you are passing in to the DTSRun executable. Nothing else gets encrypted.
The...
June 19, 2007 at 8:32 am
The quote you posted is ONLY talking about licensing. It's not addressing what your SQL Server can use. In order for your SQL Server 2000 SP3 machine to be able...
June 19, 2007 at 8:23 am
Yes, I am entirely accurate. SQL Server's 4 processor limit has absolutely nothing to do with licensing. Licensing is based on physical processor, but SQL Server itself sees logical processors.
You...
June 19, 2007 at 7:11 am
1. isql is a SQL 2000 utility. In SQL 2005, you would have to use sqlcmd.
2. QA is a SQL 2000 utility. In SQL 2005, you would have to use...
June 19, 2007 at 12:04 am
Rule of thumb #42: when asking about a query that gives an error, post the query.
June 18, 2007 at 11:56 pm
What does your DTS Package look like? How are you importing the data? Are you querying across a linked server or using a Transform Data Task?
Please describe every step of...
June 18, 2007 at 11:51 pm
Like rcavill, if I need to do a Select Into, I use 'select * into < temptable> from < table> where 1 = 0' followed by an insert into statement,...
June 18, 2007 at 11:42 pm
I do, I do!! The 4 CPU limit is logical processors. So that's 4 single CPU's, 2 double core CPU's, 2 single core hyperthreaded CPU's, 1 2 core hyperthreaded CPU,...
June 18, 2007 at 11:24 pm
If you launch the DTS Package from a bat file, and your SQL Server login is using Windows authentication, you can use the /E switch for DTSRun to use a...
June 18, 2007 at 10:52 pm
And therein is the reason that many of us are slow to adapt CLR. We're not .Net developers. I stopped doing web development about the time that the company I...
June 15, 2007 at 11:10 am
Viewing 15 posts - 676 through 690 (of 1,271 total)