Hi Sharon,

This has to do with cursors. Have a look at the following post on the msdn forums, along with the supplied link to an msdn article. That...

Rajesh,

It's changed in SQL 2005, you have to do it through setup. Have a look at this article:

http://msdn2.microsoft.com/en-us/library/ms179254.aspx

saratheamit2006 (4/3/2008)

---

Hi to all

can anybody tell me how can i create new user login in sql server 2005 for my...

Seeing as none of your functions are working let's look at the small test function you created. What do you get when you run:

select dbo.FNTest()

shine.mm (4/2/2008)

---

Hi,

What i would need is i would like to know each databases,Which are the Objects(Tables,Stored Procedures Etc.)not belong to the schema DBO.

Fist i need to know which are the...

There's no such thing as an implicit or explicit stored procedure - as far as I'm aware anyway.

You can script all the database objects (including tables if you wanted to). Right-Click on the database, go to All Tasks > Generate SQL Script and follow the instructions...

There's an even neater trick in Management Studio.

Expand the table, select the Columns folder and drag it into the query window - all columns are added in a comma-seperated fashion.

Good suggestions Mark. The first one (using the Max method) is the option to go with as that requires a third the number of reads as my method, which...

sp_help_jobschedule returns the schedule for just one job. You'd have to query the table sysjobschedules yourself to get this information out.

Peter,

You're already along the right lines. Try this:

select c.contact_ref,

...

Unfortunately there's no easy way of doing this.

The truth is though, that you shouldn't really be doing a select * from...

You should identify each field that you want to return.

Not...

Check out this article - it should get you started on the right track: http://www.sqlservercentral.com/articles/Test+Data/61572/%5B/url%5D

Jeff Moden (4/1/2008)

---

Ah ha! Finally! A challenge! If you would, post the resulting table creation script so I can duplicate what you have... the race is on!...

John Rowan (4/1/2008)

---

I'm with Jeff on this one. Since I've been into SQL Server, I have written 2 cursors. One was for analysis purposes to gather info. on...