Do you mean you want to populate columns in existing rows or add new rows? If it's add new rows then a simple insert statement will do. If the rows...
Probably got a different query plan due to statistics changing.
I suspect the only way to find out how long something has been blocked is to keep monitoring it - even then you might miss a release followed by...
Problems with this scenario are security and integrity. If you have to restore a database then they will be out of step. Permissions for the user...
I would look at the architecture of your system as this doesn't sound very supportable. Maybe get in a consultant to advise on database structure. A...
All you need to do to change the package owner is set owner_sid and owner in msdb..sysdtspackages. If you get all the package IDs into a table then...
I would try to avoid joining across servers at all. Have a look at the query plan and you will probably find that it is transferring a lot of data to...
What is the trigger doing? You can get the trigger to insert into a table the information needed then the job just actions what is in that table....
m/c doesn't support SAS and will only take 6 disks. 2 are connected to motherboard and are being kept we are replacing the other 2 existing with 4...
It's mainly batch processes. Growth won't be steady but there is loads of free space currently. Not possible to estimate what will be needed. If...
I need to get a disk controller (and 4 300G disks) for our ibm xseries 226 type 8648. The options seem to be 6i+ Controller (39R8793)...
I mever use microsofts log shipping but do the backuos, transfers and restores via stored procs. Gives you more control over what is happening. See...
How are you running the package? If via an execute package task then load the main package into the designer, right click on the execute package...
Did you leave the resored database in a condition to receive furtherlog restores? i.e. didn't recover it. Are you missing some logs? Think they...
Try leaving the profiler running to record when it happens.
It's mixing t-sql with asp. If it was t-sql it would be Declare @sql varchar(1000) Set @sql = 'Insert into [TableName] (Location,category ,user...
It looks like @execmd is a single statement so probably just removingthe try and catch statements would work. In general this wouldn't though. The...
Whatever you do the data will have to be transferred over the network Depends on your database and what you want to transfer and what your priorities...
It's much simpler to take a backup copy the file and restore it. You can do that through osql if you want a command line but I would have it call SPs...
You can put a raiserror in the step.
Separate names with a comma.
