Viewing 15 posts - 33,541 through 33,555 (of 49,552 total)
Create one trigger FOR INSERT and put the insert logic in that, create a second trigger FOR UPDATE and put the update logic in there.
March 11, 2010 at 11:04 am
Post it on Connect and see how people vote. Posted here the dev team isn't going to see it.
p.s. Why drop, create, fix permissions at all? That's what ALTER is...
March 11, 2010 at 11:03 am
wodom (3/11/2010)
March 11, 2010 at 11:00 am
Bhuvnesh (3/11/2010)
Statistics are automatically generated by sql server whenever queries executed on any table first time.
Statistics are generated when the query optimiser needs to know cardinality of a column...
March 11, 2010 at 9:04 am
winslet (3/11/2010)
on what basis, you say so ?Its a best practise to have a perfromance..
So if I have a server with only 2GB of memory in it, I can't give...
March 11, 2010 at 8:58 am
I think the safest thing here would be to script out all your jobs, alerts and anything else in MSDB and rebuild it. There are scripts available online (on MSDN...
March 11, 2010 at 8:54 am
Please post new questions in a new thread. Thank you.
March 11, 2010 at 8:49 am
If you want a list of what pages are allocated and what aren't, there's no documented way. You could use DBCC Page (undocumented) on all of the GAM and SGAM...
March 11, 2010 at 8:45 am
May I suggest, going forward, that you institute regular database integrity checks. Regular enough that, should there be a problem, restoring from backup is always an option.
Also keep in mind...
March 11, 2010 at 8:42 am
I'm kinda curious how that could happen. All the system databases should have the same collation. Did you restore MSDB from somewhere else?
What's the server collation and what are the...
March 11, 2010 at 8:40 am
Please post new questions in a new thread please, giving as much detail as possible as to what's wrong.
March 11, 2010 at 8:38 am
Truncate_only will only reduce the size of the DB is there's free space at the end of the file. Shrinkdatabase will move pages to the beginning of the file and...
March 11, 2010 at 2:22 am
Nasty.
You should do some root-cause analysis of this, otherwise it may happen again. See if there were any errors logged around the time that the DB went suspect. SQL...
March 11, 2010 at 1:51 am
Paul, is this in the SQL error log or the SQL Agent error log? If the latter, it narrows it down to something that Agent is running across. Does MSDB...
March 11, 2010 at 1:49 am
GTR (3/10/2010)
How could collation of databases is different from Server collation?
Very easily. Restore a database from another server where the server collation was different. Attach a database with a...
March 11, 2010 at 1:46 am
Viewing 15 posts - 33,541 through 33,555 (of 49,552 total)