I have been doing some readings online regarding replicating encrypted database in SQL 2005. Some indicated that 2005 does not allow replication on...
I am trying to get the created date of a file by using the sp_OAMethod. The command works fine with local drive but not any of the mapped drive....
I am trying to copy a database from server A to server B. I tried the "Copy Database" wizard and it failed at the job. Then, I decided to restore...
I am trying to run a dynamic sql statement but the statment is too long to fit into varchar(4000). When I declare @strSQL to varchar(5000), it tells...
Is it possible to import .DAT file into SQL?
I have two identical databases that each of them resides on different servers. One of them serves as the primary database where the users are...
I am new to the reporting service. I have set the parameters in the webform and wonder how to get my report to accept the parameter values passed...
is there a work around to have the reporting toolbar shown on Firebox?
I am trying to email through CDOSYS and the email is blocked as spam. Is it possible to login prior to sending the email so that the mail server...
I have a copy of the SQL Server Enterprise Edition and I can't find the reporting service on the same CD. Do I need to order a CD from MS for the...
Can someone give me some advice on how can I transfer data between two SQL Servers by using stored procedure, no DTS. Thanks!
I have scheduled a DTS to run at 2PM and 6 PM. It runs fine at 6PM but fails at 2PM. Is there a way to find out why it fails at 2PM? Thanks Bugme
Separate names with a comma.
