2005-03-15
r language
RE: Moving a DTS Job to a new server?
If you are trying to move a DTS package, edit the package and just save it to the new server.
2005-03-11
RE: DTS: Column names to Flat File limited to 248
The link in Journeyman's reply just saved me an awful lot of investigative work.. Thanks!
2005-03-10
RE: Online Repair and Recovery
To determine if there are space allocation or structural integrity problems, Database Command Console (DBCC) command. There are 6 commands that determine the granularity of the checking such as CHECKTABLE for a single table or CHECKDB for everything. See Books OnLine under DBCC CHECKMost of these checks have the option to repair but some of the […]
2005-03-10
RE: Maint plan won''''t delete .trn logs as scheduled
Have you tried the following? In Enterprise Manager, select "Management" -> "SQLServerAgent" -> "Jobs", then right-click on the job to get the pop-up menu and select "View Job History". When the job history dialog appears, select the "Show Step Details" check box. This should show more info about what's going wrong. Steve G.
2005-03-10
RE: How Can I Change the Can someone tell me a way to make a wholesale change of all of our dts packages to reflect the value of "0" instead of "-1" in the SaveMailInSentItemsFolder property value at one time
maybe www.sqldts.com contains a solution for you ?check out sqldmo ?
2005-03-04
2005-03-03
RE: Help with Data Type
I agree with Frank and Wayne - use decimal, or even float, and format the display as currency when needed.--Mike
2005-03-03
RE: SQL DBA ROLE AND DUTIES
Just one day to gather roles and responsibilities ? Well, there are good posts to go by and lots of information out on the web. I'd really think twice though before committing ... depending on ...1) the size of your organization2) the number of servers3) number and types of applications4) network and OS support5) SLA's (Service Level […]
2005-03-03
3 reads
RE: Checking SQL Server UPTIME
-- how to determin SQLServer Uptime -- Tracking Uptime by Brian Moran http://www.winnetmag.com/SQLServer/Article/ArticleID/38042/SQLServer_38042.html -- SELECT @@servername as ServerName, datediff(mi, login_time, getdate()) as SQLServer_UpTime_Minutes FROM master..sysprocesses WHERE spid = 1 go-- my own tests SELECT @@servername as ServerName, Dateadd(ss, SQLServer_UpTime_Seconds * (-1), getdate() ) as StartUp_DateTime from ( SELECT datediff(ss, login_time, getdate()) as SQLServer_UpTime_Seconds FROM master..sysprocesses […]
2005-03-02
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers