Viewing 15 posts - 3,091 through 3,105 (of 3,232 total)
Because you will need to know each tables archive table in order to create the triggers, I don't see a way to build one trigger and have it work for...
December 20, 2005 at 12:55 pm
declare @RowData varchar(100)
SET @RowData = 'http://www.google.com/intl/en_ALL/images/images_hp.gif'
PRINT SUBSTRING(REPLACE(@RowData,'http://',''),1,(CHARINDEX('/',REPLACE(@RowData,'http://',''),1) - 1))
December 20, 2005 at 12:50 pm
Are you planning on having one archive table for each of your core tables, or one archive table that needs to house all inserts to all 300 tables?
December 20, 2005 at 12:41 pm
It sounds like you've got a problem with inaccuracies in your indexes. Is your application frequently dropping and adding indexes?
December 20, 2005 at 8:41 am
What type of login are you using to call xp_cmdshell in SQL Server? Is it a SQL Server login, or are you using a domain account? If this is permissions,...
December 20, 2005 at 8:08 am
What is the error?
December 19, 2005 at 4:20 pm
Have you tried to redirect the command shell output to a file? This could give you some possible error messages to look at. If it is permissions related, you may...
December 19, 2005 at 4:18 pm
I know that you can use BCP to generate a format file. Since BCP is a command line utility, you may want to try to generate an input file programatically. ...
December 19, 2005 at 3:58 pm
I think that depends on how often your network guys are performing their file system backups. I would want the backup on tape, whether it be part of a file...
December 19, 2005 at 2:30 pm
You can kill the processes all at once using EM. If you right-click the DB and select Detach, you can clear all of the database connections there. If you do...
December 19, 2005 at 2:09 pm
It looks like you've covered many of the reasons when to use a named instance. Other reasons could be security/permissions reasons where you want the SQL Server service account to...
December 19, 2005 at 12:20 pm
select name, createdate from sysusers where issqluser = 1
December 16, 2005 at 2:35 pm
Scott does bring up a good point regarding scheduled backup times. I still don't like the idea of having a problem with one database that affects all of the others in...
December 15, 2005 at 8:07 am
It sounds like this may be a datatype issue. Make sure all of your datatypes in your SQL Server table match the data type and length of the incomming data. ...
December 14, 2005 at 3:44 pm
jeffroyal's method for renaming the file to the source filename that your DTS task is expecting should work fine. As far as only importing certain columns, I believe that you...
December 14, 2005 at 3:42 pm
Viewing 15 posts - 3,091 through 3,105 (of 3,232 total)