Actually Grant's idea is better; I haven't done that type of thing for so long I'd forgotten about it.

But just because a global temporary table is accessed from three procedures...

If you're trying to pass a value between Stored Procs (without using functions) the easiest method is probably to use a global temporary table.

BrainDonor.

You probably have three options:

Delete a 'range' of records in several executions, instead of one large-scale removal, and backup the database between these executions.

Make sure you have enough space for...

It looks like you're confusing two different types of EXECUTE.

There's the EXECUTE AS Clause, which applied to functions, procedures and suchlike,

then there is the EXECUTE (<command or character string>) AS...

I only have access to version 2005 and 2008, so I don't know if the following code will work in the version you are using:

SELECT nt_username

FROM master.dbo.sysProcesses s

WHERE s.spid...

Attached is a simple example using xp_cmdshell to create a text file of filenames (in this case jpg files from my temp directory). It then imports this list into a...

Hi GSquared,

Thanks for the code, it works fine - I appreciate the time taken to work it out. Interestingly, it detects changes to column names (which is my main interest)...

Al-279884 is correct - you've missed the DECLARE statement from within the string ParamDef:

e.g:

DECLARE @ParamDef NVARCHAR(MAX)

SET @ParamDef = N'

DECLARE @tblRules table (

tt_IDvarchar

)

insert into @tblRules(tt_ID)

VALUES (''a'')

select * from @tblRules'

--Execute the sql...

Search in the forums for "Restore Master" and you'll find a long list of articles dealing with this. One such link is:

http://sql-articles.com/index.php?page=articles/rebuildsysdb.html

I have to ask - have you tried this, prior to posting the question?

Give it a go and let us know if you have any difficulties with it.

It's been more years than I care to think about since I last used Access, so I can't comment on the code for use within that. However, there are quite...

It will truncate without any warnings. Have a look at 'varchar data type' in BOL, there's an example in there that demonstrates that.

BrainDonor.

Yes, but my understanding (recently!) is that if you use CAST/CONVERT or any other functions on a date column that is indexed, the index is not utilised, making for a...

This actually answers a question that has been bugging me for a while. Where I work now they always use CAST/CONVERT on dates going to/from Char, but at my previous...

Quite a common question within this forum:

http://www.sqlservercentral.com/articles/T-SQL/63681/

BrainDonor