Viewing 15 posts - 32,671 through 32,685 (of 39,818 total)
In SQL Server each stored procedure is like your own function and they can call each other, but htey are not "grouped" together in anyway. Instead you've had to use...
January 30, 2007 at 7:35 am
I'm not sure if the code Seygiy provided is right, but he has the correct idea for trigger design. Don't assign variables from your inserted/deleted tables. Instead use a query...
January 30, 2007 at 7:33 am
You can always set up a job to scan for autogrow being set in each db and email yourself if it is. Doesn't prevent it, but it does allow you...
January 30, 2007 at 7:32 am
Good links above and you'll certainly have some downtime when you do this, so plan for that.
I'd be sure you tackle things in stages. Personally I'd rename the server first...
January 30, 2007 at 7:30 am
Bert,
Please don't keep your opinions to yourself. I appreciate the critique. I just felt the need to defend myself a little.
We've had some posts pulled back over the years, but...
January 29, 2007 at 11:54 am
There are scripts here that will help if you really need this, but if you could answer some of Carl's first questions, we might be able to help you with...
January 29, 2007 at 7:38 am
My apologies then. The owner deleted his script, and since it was submitted anonymously, I cannot contact him or her.
For all I know it was you that deleted it...
January 29, 2007 at 7:34 am
January 29, 2007 at 7:28 am
This is correct, but the log data is not retained, so it's a question of wording.
The log still exists in simple code, transactions are logged and once they commit, they...
January 29, 2007 at 7:27 am
Interesting discussion, but I hope people don't lose sight that it's a global issue, not a US/India one. Today lots of outsourcing is to India, but tomorrow it might be...
January 26, 2007 at 5:01 pm
You are welcome and thanks.
FYI, I moved this to another forum.
January 26, 2007 at 4:59 pm
Bert,
I'd disagree immensely with your post. No scripts have been withdrawn. Someone asked a question and it was answered.
January 26, 2007 at 4:57 pm
The conference is in Denver this September.
If you click the reg link, you should go here and get a PDF: http://www.sqlpass.org/client_files/content/RegForm2007_FINAL.pdf
You need to manually fax or email this back for...
January 26, 2007 at 10:46 am
David, good for you. Have to say I like my media. Not too much stuff I watch, but sports, a few shows a week and some movies here and there...
January 26, 2007 at 10:34 am
Viewing 15 posts - 32,671 through 32,685 (of 39,818 total)