Viewing 15 posts - 42,811 through 42,825 (of 49,566 total)
rbarryyoung (11/29/2008)
November 29, 2008 at 12:14 pm
You left out the equals sign in the procedure call. You had that part right last time.
November 29, 2008 at 12:13 pm
When you installed SP2, there should have been a utility launch at the end to allow you to specify which windows accounts are sysadmin. On Vista and Server 2008, members...
November 29, 2008 at 10:12 am
Jack Corbett (11/29/2008)
They imply you memorized some canned answered and/or went to boot camp.
There's a frighteningly small percentage that actually studied the material. Not many, but there are some.
November 29, 2008 at 9:43 am
Well, your procedure (as you posted it) doesn't have any input parameters, hence trying to pass one is going to give an error.
You don't need a variable called @ColumnName, you...
November 29, 2008 at 9:38 am
Jack Corbett (11/29/2008)
November 29, 2008 at 9:34 am
Ok, that's not of much help. I hate the way the errors are cut off.
See if you can find the job that runs the maint plan. Open the job, find...
November 29, 2008 at 9:34 am
Jeff Moden (11/29/2008)
GilaMonster (11/29/2008)
Though, if you look, most of those certs are not SQL related...
True enough... but they are suppose to imply the ability to think and do a little...
November 29, 2008 at 9:29 am
Oksana March (11/29/2008)
Hi Gail,"Stop SQL" you mean stop SQL Server Agent in the Control Panel--Services?
No. I mean stop SQL server. The SQL service must be stopped before you can access...
November 29, 2008 at 9:28 am
The command I executed to stop the trace:
declare @TraceID int
exec sp_trace_setstatus @TraceID, 0
You need to set the variable to the ID of the trace you're trying to manipulate. There can...
November 29, 2008 at 9:22 am
Jack Corbett (11/22/2008)
GilaMonster (11/22/2008)
November 29, 2008 at 4:45 am
That's a pretty open question.
On the hardware side, make sure that you have planned for the new users and have capacity. eg if your CPUs are currently running on average...
November 29, 2008 at 4:20 am
Duplicate post. No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic610667-357-1.aspx?
November 29, 2008 at 4:14 am
You could write the code in notepad and compile with the command-line C# or VB compilers (which are included with the .net framework). It's a lot of work though.
Does anyone...
November 29, 2008 at 4:13 am
The error message would be really useful in trying to help you. Can you post it please?
November 29, 2008 at 4:11 am
Viewing 15 posts - 42,811 through 42,825 (of 49,566 total)