Viewing 15 posts - 1 through 15 (of 19 total)
are you member of db_dtsadmin role for that instance ?
Please refer below link for further details
December 28, 2010 at 11:56 pm
Create a new database with same physical file (mdf ,ndf ) name (on same path) and logical name.:)
Stop the sql server services.;)
replace the mdf and ndf files :w00t:
Start the...
October 6, 2008 at 9:32 am
we have scheduled all the packages using SQLServer Agent job of type Operating System ( 64 bit DTEXEC )
Please let me know why it is taking long time compared to...
June 16, 2008 at 7:28 am
Thanks for the update Steve.
We used to get the installation date using following query in SQL Server 2000
Use Master
declare @root varchar(50)
exec XP_regread @rootkey='HKEY_LOCAL_MACHINE', @key='SOFTWARE\Microsoft\MSSQLServer\setup', @value_name='SQLPath', @value = @root...
May 8, 2008 at 9:42 am
master..xp_cmdshell 'pkzipc -add drivename\path\filename.zip' drivename\path\filetozip '
Provided pkzip is installed on the server.
March 8, 2008 at 11:23 pm
replace iif with select case....
February 21, 2008 at 3:36 am
Hi Bimal,
The DTS Packages look for the associated dll 's in the local system so I believe the dll's associated with FTP components may be missing.To work around do register...
August 17, 2007 at 7:52 am
Thanks a lot Greg Charles
June 1, 2006 at 8:04 am
we know that the sqlserver service a/c should be exist in the sqlserver login to start the sqlserver successfully.if the service a/c is a domain user a/c then it will...
November 30, 2005 at 8:46 am
try using DBCC errorlog or restart MSSQL Server services.To limit the size of error log ,continously monitor the growth of error log file or limit the size of the error...
November 30, 2005 at 8:35 am
Yes u are correct these are informational messages found in SQLSERVER ERROR LOG.
yesterday we have these information messages.we have restarted the server 3 months before.
January 13, 2005 at 12:59 pm
Viewing 15 posts - 1 through 15 (of 19 total)