You can run this script to see for yourself :

if object_id('TestMyTheory') > 0

drop function TestMyTheory

GO

CREATE Function dbo.TestMyTheory()

RETURNS INT

AS

BEGIN

RETURN 1

END

GO

SELECT

Routine_Name, Routine_Type, Routine_Definition

FROM

INFORMATION_SCHEMA.ROUTINES

WHERE

ROUTINE_DEFINITION LIKE '%TestMyTheory()%'

GO

drop function TestMyTheory

GO

INFORMATION_SCHEMA.ROUTINES includes SPS and Functions (all 3 types).

Function Main()

Dim oFSO

Dim sDirectoryPath

Dim oFolder

Dim oFileCollection

Dim oFile

Dim oLog

Dim iDaysOld

'Set Variables

iDaysOld = 30

Set oFSO = CreateObject("Scripting.FileSystemObject")

sDirectoryPath = "C:\TEMP"

set oFolder...

Maybe you'd have a better chance of getting a good answer if you started a new thread instead of a finished one.

Here's the lon version to calculate the next birthday from the birthdate (I know I could've made it much shorter but I went for clarity):

Declare @BirthDate as datetime

Declare @ThisYear...

I didn't consider that before answering. But even then he didn't make any mention of why he wanted to drop the formula on the column; let's all wait for...

I read this code on these forums... I definitly didn't invent anything here .

I think Jeff is trying to do the opposite...

You can try something like this :

if object_id('Test') > 0

DROP TABLE Test

GO

CREATE TABLE [dbo].[Test] (

[id] [int] IDENTITY (1, 1) NOT NULL...

Well I can think of 2 things :

1 - Are you sure you have the right password for the sa account?

--most likely

2 - Is the authentication mode windows only...

You can't do it like this (you're asking sqlserver to select from a table variable) try :

EXEC ('Select name from ' + @Target)

please read this before using dynamic sql...

Y r u getting me involved in this Frank??

Anyways, I used cursors in production only once in my whole life (ok 13 months...

Can you show us the code and how you are using it (how you call 'em)?

This is espicially why you should always list the columns one by one in the statements. If this is production code and that the column order rechanges for any...

I don't have any experience with that. But you don't have to supply the owner. I have a link server that I Access like this :

Select *...

Just give me a few years Frank and I'll join in on that competition .

Congrats on the MVP title.