Is it okay to restore the Database from 2005 SP3 server to 2005 SP4 ?

In future if we need SQL Admin related help if you can help. Send me your...

Yes. Are you a good resource to help?

Here is the actual code. I was able to get the resequence using the ROW_NUMBER function. But now I need to get the Parent ID which will point to the...

Its not a SQL Program , it is a Progress Program.

DEFINE INPUT PARAMETER IpModule AS CHAR NO-UNDO.

DEFINE INPUT PARAMETER IpKeyValue AS CHAR NO-UNDO.

IF IpModule = "Order" then

do :

/*...

I don't really need the code blocks configured as "subroutines". But there is no easy way to share the variables and Temp Tables between SP's.

Do you have an example ? I don't necessarily want different Stored Procedures.

I need multiple SubRoutines within One Stored Procedure, so that they can share the Variables and Temp Tables.

Is there a way to create an alias for the server on the server side ?

No I didn't rename the windows server.

I have couple of SQL Instances running on the server.

I have a one named instance running on this computer, which i want to change.

I...

Creating an alias for SQL Server Named Instance.

I followed the procedure on the SQL Server to create an Alias on the sql server.

I am able to connect using the alias...

Thanks for your replies.

Here is what we want to do ?

We have a Physical Windows Cluster (SQL Cluster ) environment connected to SAN with Quorum Drive For SQL Server.

We have...

Is there a way to get the column names of the query and stored procedure to text file.

I tried bcp but it does not give a column headers just a data.

Here is the simplified query

select

m.trans_num ,

m.trans_type ,

m.lot

from matltran m

/*I want to find the top 1 record from same tables with 'WHERE trans_type...

We are not going to put it on the same network.

This will be our DR server, just in case.

Is there a way to create a identical server ?

I am not aware of CLR Procs at all. But I am open to any good solutions.

I want to write a Stored Procedure which will

- Open a PDF template...