2003-12-04
password
RE: I/O errors in error log
Sorry, Mike, I misunderstood your posting. I believe that DBCC is kind of randomly spitting out errors. The "CHECKDB..." errors being displayed for the table that has 0 rows are some examples of this. Dropping/recreating the table with 0 rows made no difference. I did try running dbreindex on 2 of the larger tables, thinking […]
2003-11-19
RE: HELP!! why one of these DELETEs does not work??
Just try Delete From QSpace.dbo.Prod_XRef Where SSN = @SSN a) i believe you need the From clause and b) if the SSN Column in your table is defined as Char(9) you shouldn't need to perform a Cast or Convert. Also looking at the message, you may need to change some of the settings in your […]
2003-07-17
1 reads
RE: image data type
Hello supercharlz, quote: how can i put an image file to my database? there are several ways for this. - using the ADO Stream object. For example like this http://qa.sqlservercentral.com/forum/link.asp?TOPIC_ID=12228 - using the textcopy C++ example that ships with SQL Server. Cheers, Frank
2003-07-16
RE: Select 2 lines into 1
I did post, in the Suggestion forum, the question about there being TWO General forums. Turns out they meant for one to be General SQL Server questions and the other to be General Programming questions. They are going to look into fixing it. I suggested either combining them or just doing: General - SQL Server […]
2003-07-11
RE: Launcing DTS packages from Stored Procedures
frere I have tried both examples in a recent project 1. xp_cmdshell 2. OLE Automation Stored Procedures Using xp_cmdshell didn't give me the flexibility of responding to failures, it will write it to the event log using the /W True option but my proc needed a response if the DTS Package fialed.Each OLE Automation stored […]
2003-07-10
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