You seem to be long on need of help and very short in supply of details.

Here is the code you posted.

DECLARE @CurrentDateTime DATETIME

SET @CurrentDateTime = Getdate()

DECLARE @nth AS BIT

DECLARE @Aus...

I know you fixed your syntax issue but I can't help but ask about your stored proc.

I assume this is getting the...

At best you can probably find...

apat (10/31/2012)

---

Thanks for the reply Brendan & Sean. I will use syscomments for sure. Just that we are planning to get rid of/move one of the databases and need to...

Mackers (10/31/2012)

---

Hi Chris,

The SQL is quite hard to read (and I have never come across case statements & cursors used like that before) but rather than using a cursor couldn't...

christopher.grant (10/31/2012)

---

I have the following code below that prints a set of results to screen using put_line but I need to display the results as a table. Is it possible...

sqlserver12345 (10/30/2012)

---

I am able to run a query in central management server created on one of the SQL servers lets say CMSServer1.

I would like to store the result set of...

apat (10/31/2012)

---

let me be clear, I would like to find out

1. if procs within other databases on the same server is using this db.

2. procs/views/functions using this database through...

You don't need SSMSToolsPack to generate a script for the data. You can right click the database Taks -> Generate Scripts to bring up the Script wizard. On the Set...

Mithra (10/30/2012)

---

Yes Sean.That right.I need to create a sp in one of my test server and have that sp to pull all the details from another server in the...

Mithra (10/30/2012)

---

Team,

I am trying to write a generic stored procedure to check all the processes running in the server.I will be using 'select * from sysprocesses.How can i...

sqldba_newbie (10/30/2012)

---

GSquared (10/30/2012)

---

I'm not clear on what you're asking for help on. I see the code, I see you want to do something in a Join statement instead of...

nfs_john (10/30/2012)

---

Hello,

My problem today is that when this company started they had no standards for data entry. So one person could enter Alabama and another Al while a third AL....

I think this should do what you are looking for but it is untested because I don't have ddl to work with.

create trigger TRG_CONTRIBUINTES_VERIFCA_RF_E_NIF on contribuintes

for update

as begin

update contribuintes

set nif...

river1 (10/30/2012)

---

The code:

Has a problem.

I want...