Viewing 15 posts - 31 through 45 (of 49 total)
Maybe this forum would be of more help to you...
http://forums.microsoft.com/msdn/showforum.aspx?forumid=91&siteid=1
August 11, 2006 at 11:31 am
August 11, 2006 at 10:52 am
And YES, you will need SQL 2005 up and running if the script is expected to create objects in the database instance.
...Michelle
August 11, 2006 at 9:51 am
Hello,
I'm not sure what type of file you were given but if it is to be used to CREATE objects on the database server then using SQLCMD utility will work...
August 11, 2006 at 9:48 am
I found a resolution that worked just fine for me:
http://www.huddledmasses.org/jaykul/importing-csv-files-to-ms-sql-2005/
...Michelle
August 10, 2006 at 10:59 am
I don't quite no the INTERNALS but this was observed on SQL Server 7:
http://www.windowsitpro.com/Article/ArticleID/14298/14298.html
see #9 under Ugly (or just different)
------------------------
9. Another reason for tables growing in size is...
August 9, 2006 at 12:25 pm
Do you have any error checking enabled within the package? (click inside package, properties, designate a error log file location):
Also who is the JOB being executed by...right click on...
August 8, 2006 at 8:10 am
EXCELLENT TOOL FOR ANY DBA especially during the period of SOX compliancy!!! THANKS A BUNCH...
...Michelle
May 16, 2005 at 10:35 am
Here how I have mines automated...
DBCC SHRINKDATABASE (N'datbase', 0,TRUNCATEONLY) -- for SINGLE db
exec sp__msforeachdb "DBCC SHRINKDATABASE (N'?', 0,TRUNCATEONLY)" -- for ALL db on server
Please see BOL for future info about...
March 14, 2005 at 2:50 pm
sorry...domain is DomainNT\P.C. Support..
sid status createdate updatedate accdate totcpu totio spacelimit timelimit resultlimit name dbname password language denylogin hasaccess isntname isntgroup isntuser sysadmin securityadmin serveradmin setupadmin processadmin diskadmin dbcreator...
December 17, 2004 at 1:26 pm
Yes, I have all that in order...
sid status createdate updatedate accdate totcpu totio spacelimit timelimit resultlimit name dbname password language denylogin hasaccess isntname isntgroup isntuser sysadmin securityadmin serveradmin setupadmin...
December 17, 2004 at 1:24 pm
Thanks a bunch all...I used Shaun suggestion and it worked like a charm...
Again THANKS
December 10, 2004 at 9:31 am
Viewing 15 posts - 31 through 45 (of 49 total)