I found this blog entry that has some examples of this:

http://blogs.msdn.com/raulga/archive/2006/07/03/655587.aspx

Greg

No, an index must be dropped and recreated in SQL 2000.

Greg

As Ryan said in his first post, there is a task for copying objects between SQL Server databases - the Transfer SQL Server Objects task.  The hitch most people hit...

While the feature isn't available in the import/export wizard anymore, it is still a task in SSIS called Transfer SQL Server Objects task.  You have to create an SSIS package...

Brian,

sp_who2 gets program_name from sysprocesses, so join sysprocesses with sysjobs after converting the binary value.  I use this query in a "send email" step of a job that checks for...

George,

There's a script posted on this site which purports to delete old package versions.  I haven't tried it, but I respect the author's knowledge of SQL Server.  Find it here:...

Alex,

I'm not quite sure what you want to do.  Do you want to install SQL Server on server2 and transfer a database to it, or do you want to leave...

Run this in QA, then run the results:

select 'exec sp_changeobjectowner ''' + name + ''',''newowner'''

from dbo.sysobjects

where xtype in ('U', 'P')

Greg

DTSBackup2000, available for free download at http://www.sqldts.com, will save multiple packages at once.  That saves you the trouble of opening and saving each package individually.

Greg

Tim,

It's been a while since I worked with Oracle and the formal training I got was from the company's Oracle Education division (http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=3&p_org_id=1001&lang=US) .  I've gotten excellent SQL Server...

"Just execute the script in query analyzer and it will create the jobs"

or, since this is SQL 2005, in a query window of SQL Server Management Studio.

Greg

Ah.  My suggestion is to import the Access table again into a different table in SQL Server then run an update statement to change the data in the bad column. ...

Juanita,

What needs to be changed about the column that the developer says is wrong? 

Greg

So, is the file path on the server the same as the path on your local machine?  In other words,  is there a C:\ETL\ or C:\test.mdb on the server?

If the...

This bit

Exec prc_Performance_proc

'insert [dbo].[SC_Performance_table]'

looks like you're supplying a value for a parameter in prc_Performance_proc when, in...