Viewing 15 posts - 28,321 through 28,335 (of 39,771 total)
DDL triggers are good for finding stored proc changes.
If you want data changes from a specific proc, Profiler or a server-side trace. You could log things into another database.
June 4, 2008 at 9:56 am
Do you mean the query files open again automatically? I don't think this is possible. You can open SSMS and have a file open, but not sure it automatically opens...
June 4, 2008 at 9:55 am
Not sure. This is a simple process that should work. I'd uninstall, reboot, reinstall. Might be something flaked.
June 4, 2008 at 9:52 am
Less is more, use few slides, don't read them, put information on them you will talk about, but other than a way to keep people organized, I wouldn't use Powerpoint.
If...
June 4, 2008 at 9:18 am
You never know who will win. I wouldn't think that anyone who posts a lot on the site has much more of an advantage than someone that posts little. It's...
June 4, 2008 at 9:14 am
Thanks and the comparison is to stimulate debate. Think about it, we teach and learn by example, we are always comparing A to B, trying to better understand the world.
Lots...
June 4, 2008 at 9:12 am
Correct, a .bak is used in DR situations. There will be no MDF/LDF. They will be created during the restore process, at the sizes needed for the backups.
You can look...
June 3, 2008 at 6:28 pm
If you need to use languages outside English, then use Unicode. If you are sure you won't, then stick with regular varchar.
June 3, 2008 at 6:27 pm
There are lots of ways to do this, but most of them come down to being organized and standardized in how you approach deployments.
I wouldn't give anyone Visual Studio...
June 3, 2008 at 6:26 pm
Use a production backup and obfuscate the data.
Buy a tool. Red Gate has a data generator you can use.
June 3, 2008 at 6:24 pm
In this case GUIDs are a better choice. You can use identities, but pick ranges for each system, large ranges, if you do.
June 3, 2008 at 6:23 pm
Don't cross post.
Answered here: http://www.sqlservercentral.com/Forums/Topic511041-146-1.aspx
June 3, 2008 at 6:22 pm
I must also point out that the terms "sloppy" and "specialist" are NOT mutually exclusive.
How true, how true.
The measure of a person is how well they do the work and...
June 3, 2008 at 2:10 pm
Project Management is a big part of it, but it's also how we want to be perceived by other groups and people in general. I think IT has a fly-by-night,...
June 3, 2008 at 12:31 pm
The download has been updated to correct a few bugs, courtesy of Mr. Bird.
June 3, 2008 at 12:27 pm
Viewing 15 posts - 28,321 through 28,335 (of 39,771 total)