I have a batch file with three lines as given below:
cd C: empIncomingFilesBOKDecrypted2009-11110209
rar.exe a C:...
Hi I have a table as given below:
Seq TrxDate SUBP
100 2009-07-01 00:00:00.000 NULL
100 2009-07-02 00:00:00.000 NULL
Can someone direct me to a url where I can find the details to upgrade an existing SQL server 2005 developer (x32) to SQL server 2005 Enterprise...
After I run the command DBCC SHRINKDATABASE <DB Name>, is there a way to find out how long it takes to shrink the database and how much is...
I am in the process of analyzing the customer requirements for setting up ad hoc reports. I am not clear with respect to the following two...
I have the following configuration for prodn server:
Node1: Win 2003 server x64 + SQL server 2005 x64 Ent (one sql instance)
Node2: Win 2003...
I have the following environment:
Win 2003 server x64 (Ent) with SQL server 2006 x64 (Ent), two nodes (db1 & db2) are clustered with one instance...
I just completed the installation of a active-active cluster. one SQL instance in each node.
I did manual failover and every thing works...
Can I run a SP in a job step with in a transaction?
Declare @Status bit
Declare @ErrMessage varchar(100)
I need to create databases in production server Active/Active cluster.
Each node with one SQl instance and databases. Each node has 8...
I have two new servers with Windows 2003 64 bit enterprise servers with SQL 2005 64 bit enterprise nstalled.
There are four processors and 8 GB...
I am using Asymetric encryption.
I am seeing differenr encrypted values for the same string each time I encrypt.
Is this normal behaviour?...
What is the command line syntax to connect to SQL Server 2005 using sqlcmd and windows domain account.
i am using C:sqlcmd -S US-Tex-Test -U...
I did see a questions and answer to the above. But I could not able to get into the links provided in the reply.
I have an existing transactional...
I have to design couple of snapshot reports. These reports are not supposed to run on a schedule. They must run based on a event. That is when...
I am not able to connect to local server using SQl Server MS. This was working correctly for quite some time. All the services are running.
I have a requirement in SSRS.
The customer wants to have snapshots generated at regular intervals and be available for 14 days on line. After 14...
I have a application developement taking place. I noticed that there are 4 tables with foreign keys in a cyclic way. That is I could not able to...
Can some one explain the procedute to load a table (multiple columns) using a xml file.
It would help a lot if there are examples.
I would like to know if it is a good idea to store the content of a text file (about 2 MB) in a table column (varchar(max)).
This data will not...
Separate names with a comma.