Viewing 15 posts - 15,256 through 15,270 (of 39,970 total)
Are you looking to duplicate the affected tables? If you wrapped it in a stored proc, I believe the Red Gate Dependency Tracker would tell you which tables, and then...
September 15, 2011 at 9:28 am
Closing this thread as a duplicate.
Please do not attack other members when they post. Regardless of your time critical situation, this is a volunteer forum. If you do not like...
September 15, 2011 at 9:19 am
Change the password requirements for Windows 7. http://windows.microsoft.com/en-US/windows-vista/Change-password-policy-settings
September 14, 2011 at 10:16 am
CREATE TRIGGER myTrigger ON myTable
AFTER UPDATE
AS
BEGIN
If UPDATE(column1)
-- returns "new" updated value
select column1 from inserted
-- returns old, pre-update value
select column1 from deleted
September 14, 2011 at 10:10 am
There is a shared lock (S) on the data, but that prevents exclusive locks being placed on the page/row/table for changes. It doesn't impact read performance.
As you noted the data...
September 14, 2011 at 10:09 am
Ugh. Tim Mitchell had something similar that he did in a presentation to skip headers when using SSIS, but you could easily redirect the headers to another table, as Sean...
September 14, 2011 at 10:07 am
I don't think there is a way to do this. You could make a SQLCMD batch file and use that.
September 14, 2011 at 10:05 am
I thought that you could specify the default db location in setup and all databases went there, including system ones.
September 14, 2011 at 10:04 am
If you have systems center, or an equivalent, or want to do WMI scripting, you can probably initiate scans across your various Windows hosts to get a list of all...
September 14, 2011 at 9:45 am
I think learning those obscure items, and understanding those can make life richer and more interesting. I'm surprised sometimes how things from other subjects impact the way I look at...
September 14, 2011 at 9:44 am
There are a few ways to handle this.
The easy way is to use SQLCMD and a little scripting to connect to each database in turn and run a script.
One is...
September 14, 2011 at 9:43 am
Congratulations to Jeff. He is an excellent choice as the recipient of this award.
September 14, 2011 at 9:37 am
They need at least one copy of master, model, msdb to start. It might give errors with the various databases, but once it starts, you can then do a restore...
September 14, 2011 at 9:06 am
jay holovacs (9/14/2011)
Lempster (9/14/2011)
September 14, 2011 at 9:04 am
This problem with the question is entirely my fault, not Ron's. I copied over the code, making a mistake after testing it when I was correcting formatting. The second set...
September 14, 2011 at 8:44 am
Viewing 15 posts - 15,256 through 15,270 (of 39,970 total)