Viewing 15 posts - 42,796 through 42,810 (of 49,571 total)
You don't have to specify a mirror, but you can. It was the same in SQL 2005. No changes in that area.
Books Online SQL 2005:
The data-access provider, whether SQL Native...
November 30, 2008 at 7:25 am
barb.wendling (11/30/2008)
I was not able to delete the trace files after the trace was stopped. Can you explain why/how to remove these files?
If the trace is stopped and closed (not...
November 30, 2008 at 6:49 am
mike (11/29/2008)
I cant see the temp table in management studio?
Temp tables are local to the connection that creates them, they cannot be affected by anyone else and they are...
November 30, 2008 at 3:52 am
Hmmm.....
I know there were some issues with the maintenance plans in SP2. They were fixed in a re-release of SP2, but you've got the initial release of the service pack....
November 30, 2008 at 3:51 am
Change tracking
Change Data Capture
SQL Audit
November 30, 2008 at 3:48 am
I typically use triggers for auditing, though that use is getting reduced or eliminated on SQL 2008.
November 30, 2008 at 2:49 am
You've left a lot of important information out.
32 bit? 64 bit?
What OS
What edition of SQL 2005?
How much memory does the server have?
November 30, 2008 at 2:49 am
Jeff Moden (11/29/2008)
Your good explanation is, of course, the most accurate... I was just trying to give a 30,000 ft overview.
No prob. I was just worried that someone...
November 30, 2008 at 2:45 am
Jonathan Kehayias (11/29/2008)
GilaMonster (11/29/2008)
Does anyone know if Visual Studio Express allows database projects?
Gail,
The Visual Studio Express Editions don't include database projects in them, at least the last time I checked...
November 30, 2008 at 2:45 am
Hmm. That almost looks like the main plan's corrupted. Can you try recreating it? Can you also try backing up to that device not using the maint plan?
November 30, 2008 at 2:41 am
rbarryyoung (11/29/2008)
Like everyone else, I don't know everything, even in SQL Server (well, Gail might know everything, she's pretty darn close)
Hell, no! Plenty areas I don't know well (and that's...
November 29, 2008 at 3:32 pm
Two more things.
Stored procedures should not be created with the sp_ name, That's for system procedures and means that SQL will look in one of the system databases first for...
November 29, 2008 at 3:23 pm
TCP Chimney I don't know. May I suggest a google search?
As for CU9, providing you're on SP2 (which I assume you are), you can request the cumulative update from microsoft....
November 29, 2008 at 3:21 pm
You're passing the value invoiceid to the procedure, but you're doing nothing with it within the procedure.
If you want to use the parameter to filter the query, it needs...
November 29, 2008 at 3:15 pm
I'd guess there's no data for the period in 2008 within the invoices table.
November 29, 2008 at 2:57 pm
Viewing 15 posts - 42,796 through 42,810 (of 49,571 total)