Viewing 15 posts - 30,121 through 30,135 (of 39,919 total)
third vote here for Jeff's suggestion. Use names that describe what the procedure does, not what it accesses.
January 7, 2008 at 7:49 am
You can set up some monitoring using alerts to look for certain events to fire, but not necessarily all Windows events. If you need something that occurs in Windows, use...
January 7, 2008 at 7:09 am
Good luck on the next one, but I'd recommend you beef up your DBA skills at least so you know how to answer questions like that. These days lots of...
January 7, 2008 at 7:05 am
Sorry 🙁
You can see them here: http://www.eweek.com/slideshow/0,1206,pg=0&s=26744&a=222190,00.asp
January 7, 2008 at 7:02 am
There are lots of scripts here on the site in the Scripts section that do these things. You can search a few out and modify them to suit your needs.
January 7, 2008 at 7:00 am
The error is because CREATE PROCEDURE needs to be the first thing in the batch. after the "Use Test", you need a "GO" to break the batches.
January 7, 2008 at 6:59 am
You could do a RAISERROR and get some info, but other than that, I've checked with the MVP groups and there's no way to do this with PRINT. Someone did...
January 6, 2008 at 9:53 pm
Agree with DAvid. Show us some work, some examples, DDL, data, etc. along with what you've tried and why it doesn't work. We're happy to help point you in the...
January 6, 2008 at 9:52 pm
You can do this, but it's not recommended. Any network hiccup will result in this failing. Better to back up to a local drive and then copy to a remote...
January 6, 2008 at 9:50 pm
What is your question? Does Google pay better? They might, but it depends on the individual.
January 6, 2008 at 4:55 pm
We don't use a scripting language per se. You've asked a question that doesn't make sense.
The site is programmed in ASP.NET and C#.NET, but not scripted. Perhaps you could count...
January 6, 2008 at 4:55 pm
What type of training?
There is no "best" training, it depends on what you need done.
January 6, 2008 at 4:48 pm
Security for one, depending on how the application is configured. Also you just have more complexity in ensuring that things work smoothly and troubleshooting if they don't.
If this is a...
January 6, 2008 at 4:47 pm
Or build in auditing triggers (DML or DDL) to keep track of what changes.
January 6, 2008 at 10:28 am
Viewing 15 posts - 30,121 through 30,135 (of 39,919 total)