Viewing 15 posts - 39,601 through 39,615 (of 39,716 total)
Can you upload into a temp table and then do a join to insert into the real table?
Steve Jones
August 23, 2001 at 10:46 am
August 23, 2001 at 10:45 am
If this is SQL 2000, you probably want the dynamic properties task. You can use teh results of a query to alter the data xfr task.
Steve Jones
August 22, 2001 at 10:11 pm
That will work, but uses system tables (unsupported). I'd try to avoid that if possible.
Steve Jones
August 22, 2001 at 4:41 pm
There is no stored proc, but the output of exec sp_who2 contains a lastbatch column. This is the last date/time when a batch (or command) was executed by the column....
August 22, 2001 at 2:33 pm
August 22, 2001 at 2:23 pm
August 22, 2001 at 2:22 pm
Not that I know of. These are encrypted with the understanding that they will never be decrypted.
Steve Jones
August 20, 2001 at 12:17 pm
I think you need to monitor the page splitting. When you have the low fillfactor, if the insert occurs in the middle, then there can be a performance issue due...
August 20, 2001 at 12:13 pm
You need to change the server name in SQL.
Use sp_dropserver, sp_addserver with the LOCAL option.
Steve Jones
August 20, 2001 at 12:09 pm
You need to change the server name in SQL.
Use sp_dropserver, sp_addserver with the LOCAL option.
Steve Jones
August 20, 2001 at 12:09 pm
August 17, 2001 at 8:41 am
August 15, 2001 at 9:34 am
I had a similar problem. I rebooted the server, then stopped the SQL services and was able to get the script to run.
Steve Jones
August 15, 2001 at 9:33 am
Usually when you connect through a COM object, the object proxies the user account. In other words, the user account is not used to connect to SQL Server, the account...
August 15, 2001 at 9:27 am
Viewing 15 posts - 39,601 through 39,615 (of 39,716 total)