RE: SQL Mail Doesn''''t see any profiles....
I have it working now. I had to go into internet options in control panel and set outlook as the default mail client. Somehow outlook express was the default.... Allan
2005-02-08
Warehouse
RE: tools to document a database?
Erwin and Visio can reverse-engineer tables/views. SQL itself can provide the code for all objects and you can look at sysdepends/syscomments for additional information (may not always be 100% accurate though)
2005-02-03
Conditions that cause SQL to change its dynamic listener port.
I was wondering if anyone could tell me or point me in the direction of a white paper. When SQL 2000 SP3 is configured for dynamic port allocation, what conditions would cause it to change its port? IE I need to be aware of Listener port changes.Thanks
2005-02-02
1 reads
RE: Leap Year got Me ... Help!
IF ISDATE(CAST(DATEPART(YEAR, GETDATE()) AS CHAR(4)) + '-02-29') = 1 BEGIN PRINT 'Leap year' END ELSE BEGIN PRINT 'Not a leap year' END
2005-01-19
RE: Problem with CAST
Or you can eliminate the CASE altogether and do something like thisSELECT 'ST_GR' = RIGHT('0' + CONVERT(varchar(2),ST.GR),2)
2005-01-19
is possible to add a trigger in the table SysObject?
Is possible to add a trigger in the table sysobject??
2005-01-19
2 reads
RE: Numbering of Records
You can use the function COUNT_BIG() instead which returns a bigint. It uses the same parameters as the count() function.
2005-01-19
RE: Finding Stored procedures being used
Don't forget the thing about change control. It's better to work on that as well, so it is ready when you're done with the mapping. If not, it may be too tempting to go around it while waiting for it to become real, and before you know it, you might have to do the work […]
2005-01-19
RE: altering column from datetime to varchar eliminates seconds and milliseconds part
or you could use this:select convert(varchar(12),getdate()) + right(convert(varchar,getdate(),126),len(convert(varchar,getdate(),126))-charindex('T',convert(varchar,getdate(),126)))result = Jan 19 2005 08:48:19.397 depending on your preferencing for displaying the date to your users. regards, Mark Baekdal http://www.dbghost.com+44 (0)208 241 1762 Database change management for SQL Server
2005-01-19
RE: DTS and "Flags"
Hi, Happy New Year There are two very basic options. The first is to generate a DTS package that performs all the tasks you need, alternatively, you could split the tasks into smaller DTS packages and schedule them as ‘Jobs’ (under management folder (if using 2000)). In both options you have a precedence order so […]
2005-01-05
Blogs
Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
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