Forum Replies Created
Viewing 15 posts - 466 through 480 (of 588 total)
-
RE: SQL Server 2005 cleanup of old backups is not happening
Which service pack are you on? Before SP2 the cleanup task would not correctly cleanup subdirectories.
-
RE: SystemTables (SQL 2000): Find a Field in a Table
Use the id for the table and select out of the syscolumns table for that ID.
select
a.name as
April 20, 2007 at 8:07 am
-
RE: Error while running DBCC CheckDb
Change the default for the database to True for Arithabort.
Of course make sure that there is no reason why it is false...
-
RE: Restore db from network location
Mapped network shares are not visible to SQL when running on Windows 2003. To restore from the network have to be done using UNC like Amit showed above.
-
RE: function for delimiters
Is it ok to cheat?
How well defined is the data? If just like you said there, the following would work... -
RE: Executing gzip or sslftp from within an SSIS Package
how about using xp_cmdshell from an Execute SQL Task? Haven't tried that from within SSIS but....
-
RE: t-sql/xp_delete_file problem
For clarity here is the entire script I use for cleaning up all my backups. I posted the script I run for my backups somewhere else around here the other day......
-
RE: What are general problems faced during dev to prod restore
ok assumming the DEV means a development environment, and PROD means a current production environment. Why would you want to overwrite your production environment with what you have in development?
-
RE: Tempdb suspect
You should only need to restart the instance of SQL server that needs a fresh tempdb. Not restart the server itself.
-
RE: Backup Database Corrupt
Try to restore with Continue_After_error, although I think the backup had to be made using the Checksum option to use it, so it might not be much help.
http://blogs.msdn.com/sqlserverstorageengine/default.aspx
-
RE: Default NULL not working
Please provide the create script for the table, and the insert statements you have tried.
-
RE: Start in single user mode
Does the same happen when you use net start with /m as well?
-
RE: sa password
Must be a CRM application!
We had one like that at my previous job, all it needed was to be able to create tables...
-
RE: Adding date timestamp to a backup file name
The following gives you excatly the name as SQL would using maintenance plan. Does it for all databases so I do not have to create a new one when I...
Viewing 15 posts - 466 through 480 (of 588 total)