Hello All, Is it possible to achieve the below desired output, using one query only? date starttime endtime length field1...
Hi All, Is it necessary to drop the symmetric key, certificate, and database master key every time we encrypt/decrypt data? Thanks, Jon M
Hello All, I will be creating 2 SSIS projects. They have similar flow for now but later on one project will change gradually (new flows will be...
Hello All, I have a temporary table which I truncate everytime I run my process - the same process will then insert new records from another source...
Hi All, I am trying to import records from table1 to table2 but I want to exclude table1 records that are already existing on table2. If the same...
With SQL Server 2000 DTS, we can dynamically change a global variable using the Dynamic Properties Task. I understand that Dynamic Properties is no...
Hi All, I got a problem with my Windows 2003 server that went unresponsive whenever I try logging in using remote desktop...all I see is a gray...
Hello All, I am planning to move all databases (including system databases) from one server to another. The new server will have the same config...
If I will be switching from SQL Server 2000 to 2005, where can I get a list of all deprecated commands or no longer acceptable in SQL Server 2005?...
Hi All, I am trying to pull a subscription to another database, let's name it as 'SERVER_A'. I have 2 Publishers. I can publish articles on both...
Hi All, Is it possible to call an ASP page from stored procedure? How? Thanks, Jon M
Hi Everyone, I have a DTS that transforms data and this is going to be a daily thing. How can i dynamically create the destination file name? For...
Hi,<br />Is there any alternative solution on trapping Bulk Insert error in SQL Server 2000 aside from upgrading to SQL Server 2005 and use TRY and...
Hi All, We need to perform maintenance that requires all servers to be shut down. What is the proper way of shutting down SQL servers that are...
Hi, Our reporting SQL server service was deliberately stopped yesterday by one of the staff thinking that it will resolve blocking processes caused...
Hi, Assuming I have 40 articles, is it advisable to have each article being published to have its own subscription (in this case 40 subscriptions)?...
Hi, Anybody knows a link or doc that talks about replication that uses private network? A step-by-step would be great! Here's my plan: 1. Setup two...
Is there any alternative solution for sorting records randomly without using ORDER BY NEWID()? Any ideas will be highly appreciated. Thanks, Jon M
Anyone ever implemented column encryption and decryption in SQL Server 2000? Let's say I would like to encrypt and decrypt password or credit card...
I restored a SQL server 2000 (SP3) database that is being replicated from a new sql server instance. Replication was broken from this new instance...
Separate names with a comma.
