Hi Peter,

If you want this script working with different database then you need to use fully qualified name in the form database.schema.object_name in queries and also to add database id...

I've just tested it and script works (as expected) in SQL 2008 but not in 2000 as Sunshine tried. Sorry

Hi Luis,

It looks that problem was just in copying script from web page to query window. It added some special characters.

You can find file with unchanged script attached. I...

Hi Luis,

This script was written while SQL 2000 was actual version. I'll be back when I do test (or rewrite) on 2008.

Boka

One thing you can do (even if it's not a secure way) is to map this share using particular credential:

exec @Return = master..xp_cmdshell 'net use mapletter: \\server2\sharename pwd /user:domainname\username'

......

Jerome,

Look for "partitioned tables [SQL Server]" in BOL 2005!

Hi Dave,

Try this SQL script. If it works as you want just uncomment commented line. It's a good idea to create SP having old and new names as input parameters....

Think about grouping with rollup. It's very useful option.

Hi Jeff,

I've seen a lot of discussions here but no one mentioned indexes and choice of clustered one. What you can find in practice is that db designers usually create...

Everything you need about SP2 is on http://technet.microsoft.com/en-us/sqlserver/bb426877.aspx

Try with left outer join instead of inner join.

For everyone who wants to be a database professionalist:

1. Read this article;

2. Learn from C.J. Date books;

3. If you survive - start your database work.

PCI,

Create command is "hidden" cause I'm not using create DDL command but Select ... into

Procedure spCreateJournal (follow variable @SQLCommand) will create journal table if it doesn't exist.

John, don't escape using return value. Let's see another scenario for proc:

Alter Procedure dbo.MyTestProd @RowCount as int out

As

begin

declare @RetValue int

Update dbo.t1 set dbo.t1.f1 = 2

select @RowCount = @@Rowcount, @RetValue =...

Alter your proc adding return statement like this

Alter Procedure dbo.MyTestProd @RowCount as int out

As

begin

Update dbo.t1 set dbo.t1.f1 = 2

set @RowCount = @@Rowcount

return @RowCount

end

and now you can execute it...