Hi, I have a batch file with three lines as given below: Echo off 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 100...
Hi, Is the following command is right one to upgrade SQL server 2005 Developer to SQL Server 2005 Ent? Setup.exe /q /ACTION=editionupgrade...
Hi, I got this from collegue.select Session_ID,percent_complete, estimated_completion_time , cpu_time, total_elapsed_timefrom sys.dm_exec_requests...
I will look into the link. Thanks, Gopal
HI, 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...
Hello, 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...
Hi, 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...
Hi, I have the following configuration for prodn server: Node1: Win 2003 server x64 + SQL server 2005 x64 Ent (one sql instance) Node2: Win 2003...
Hi, 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...
Hi, Can you detail how to check this "But if you are running SQL Server 2005 on Windows 2003, check if the SQL Resource Proprety "Failover Group" is...
Thanks Dinakar and Satya for your quick reply. I have one more question, I did not install integration services in any of the instances in cluster. I...
HI, I just completed the installation of a active-active cluster. one SQL instance in each node. I did manual failover and every thing works...
HI, Can I run a SP in a job step with in a transaction? For example: Declare @Status bit Declare @ErrMessage varchar(100) Begin Tran Exec...
Hi, I need to create databases in production server Active/Active cluster. Each node with one SQl instance and databases. Each node has 8...
Hi, Thanks for your quick reply. can you please eloborate a little what you meant by "true 64-bit across the board". thanks, Gopal
Hi, 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...
Hi, I am using Asymetric encryption. I am seeing differenr encrypted values for the same string each time I encrypt. Is this normal behaviour?...
Hi, Thanks for your quick reply. Here is the scenario, some one logs into the box as local administrator and Local administrator has no access to the...
Hi, 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...
Separate names with a comma.
