SQL Server 7.0 Agent fails every once in a while
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-04-26
PowerShell
Detaching and Attaching database
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-04-26
RE: Link between DB2 and SQL2000
You need the ODBC drivers from the Linux side to access the SQL Server. Not sure since I haen't done this, but it should work if the DB2 Federated links work like Linked servers in SQL Serever
2004-04-25
RE: format ssn
Ok, this is simple. Create a Stored Proc for saving data into that Table. In that Proc, Clean the data!!! I ALWAYS create a Stored Proc for Saving and Deleting, and use Functions for retrieving complicated data. The fact that Stored Procs are used for "Business" Logic makes them the ideal location for complicated […]
2004-04-23
RE: New to DTS, help needed with creating a package!
Here's the Outlook part. Put this in the ThisOutlookSession class (open Outlook, hit Alt-F11, hit Ctrl-R, expand Microsoft Outlook Objects, open ThisOutlookSession). This reviews your inbox every time a message is added to it. If the message has a subject of "Usual Suspects" it takes the attached file and moves it to a folder called […]
2004-04-20
RE: Simple Varchar Sizing Question (SQL 7.0)
As far as I'm aware, from a storage point of view, no it doesn't really matter. SQL Server will not pad out a varchar column and hence it will only take as much space as it needs (it will also truncate any trailing blanks if you have ANSI_PADDING set to OFF when the column is […]
2004-04-19
RE: Error 21040:Failed to create during setup merge publication
run sp_helpmergepublication from the publisher in the publication database to check if the publication really exists.
2004-04-16
RE: Review of SQL2K Resource Kit
Hrm. It was on sale at Amazon still as late as last week if I remember right. I see even Bookpool.com is out of stock. However, it is on-line at Microsoft so there is a silver lining.
2004-04-13
1 reads
2004-04-09
RE: Disable sa account in 2000
Hey mom,My last posting was only to reply to the suggestion of "disable SQL Auth." sa is not used anywhere. Thanks for your concern.Steve DiDomenicoNashua, NH
2004-04-07
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
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...
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