Viewing 15 topics - 279,511 through 279,525 (of 280,487 total)
In the current FAQ page, nothing identifies an FAQ that has been posted or modified recently. As a…
K. Brian Kelley
21 years, 9 months ago
By: Brian Knight
Does anyone have a table to convert SQL's xtype to ADO's data type constant?
xtype = 5…
My question is does the FORMAT file have a specific format or structure, I specifically want to kn…
By: Steve Jones - SSC Editor
I have a problem with a one time DTS package. I have an access DB with one table in it, co…
In: Data Transformation Services (DTS)
By: Tom Goltl
This is a very general Q, but ive noticed a number of times that a schema change (ie. new c…
By: K. Brian Kelley
Hoping someone has run into something like this before. The server running our SQL 7 is also our pr…
We have just ordered a new server for our SQL Server to go on. What I was wondering was: what's…
I have always used full backups to backup databases. Tansaction log backups are used for databases…
Robert W Marda
My stored procedure look something like this. I'm running on sql server 7 and I have local …
I want to send an email to a user based on criteria in a table. Such as if TimeAcknow is greater th…
The vulnerability has hit the major computer news outlet. The discoverer of the exploit, under the…
In: Anything that is NOT about SQL!
I want to store the ouput of select * from <table> for xml auto,elements
into a variable.
By: Andy Warren
I am having a terrible time trying to update to any serice patch. It is looking for a password for…
By: Wesley Brown
We have a Merge Replication between 2 SQL2K.
the subscriber went down for a while and then it's…
I've built a FTS, and when 200 records (about 100K/record) it's OK. But when 500 records, after i s…