What's the MS-SQL Server equivilant of the oracle command Minus.
For those that don't know this command it's similar to a union. here's an exmple
Select field1, field2 from table1
MINU...
I'm running SQL Server 2000 with SP2.
I've been off for a while so i'm not sure about it's history.
I try to set up a transactional replication on it it stops the TCP/IP port listening e...
I just can't seem to remember the correct way to do BCP using trusted connection (NT Authentication). I checked BOL and all the examples I ever see always have -U and -P. Does anyone have th...
1) How to Call a stored procedure of a database from with in the stored procedure of a different database
2) How to execute a Query for a tabale of database from with in the stored procedur...
Hi,
I need to build a dynamic sql statement and return the
result into a variable.
I'm able to build the sql statement, but I don't know how
to keep the result into a variable...
Exam...
I am attempting to set up a simple snapshot replication between two SQL 2000 servers. I have set a machine up to do a pull replication from another machine. The setup process seemed to work fi...
Found this in the SQL log. Does anyone know what it means? Why would it place an entry in the log when it uses a particular dll? Is is something that I should be worried about?
Thanks fo...
Hello,
How do I get my select to return .500 as opposed to .5?
tks
steve
I am facing a problem with the varchar data type in Microsoft SQL Server 7.0
Whenever I use this datatype its length doesnot automatically increases to accomodate the characters although th...
Hi All,
I'm trying to recover my database server (SQL 7.0) using sp_attach_single_file store procedure.
EXEC sp_attach_single_file_db @dbname = 'myData',
@physname = 'c:\mssql7\d...
I have a problem. When I attempt to open a DTS package from the client machine I get the following error returned
Title: DTS Designer Error
Message : ||||||||
The DTS package runs OK ...
