Have you installed Standard edition on the new server?  You'll have to do that before moving anything from the old server.

Greg

We've recently installed a named instance of SQL 2005 on a server that already had a SQL 2000 default instance and we haven't had any major problems.  Neither version has...

Doh!  You're trying to find which table contains a column with a specific name!  Use this query to list tables that have a column.  Just replace 'columnname' with the column you're searching for...

The data stored in the identity columns will be replicated to the target tables, but the identity property itself will not be.  That should be fine for you because you...

You'd have to query the tables.  Does the column have the same name in all the tables?

Greg

Would you elaborate a bit more?  Are you searching for a column value in all the tables of a database?

Greg

You can't do that.  You restore a database to the state it was in at a point in time.  In your case, that's the point when the complete backup was...

It's been a while since I imported from Oracle.  I think I used the TO_CHAR function to convert dates to strings in temp Oracle tables then imported into the SQL Server tables...

Mike,

Rebuild the table with the first column being an integer IDENTITY (1,1) NOT NULL.  Then, run the import/export wizard again and make sure the three fields in the input file...

We have always moved to new hardware without moving system databases and we've never had a major problem.  We use the methods described in this article: http://support.microsoft.com/kb/314546/en-us.  We've gotten...

I use this query to find jobs that have been running for more than an hour:

select RTrim(J.Name),last_batch

from msdb..sysjobs J with (nolock)

       inner join master..sysprocesses RP with (nolock)

                on...

"so is there any way to control his powers/permissions which he can only apply his permissions on some specific objects"

No.  As I posted before, there's no way to restrict sysadmin...

Yes, you can by using the 'with move' option of the RESTORE DATABASE command.  See 'RESTORE DATABASE statement' in BooksOnLine.  There's an example under '

I don't currently use log shipping, but I believe that's done so the primary database will be in a recovery state and ready to receive log backups made on the...

Here's a way to search stored procedures, views, and UDFs:

declare    @Target varchar(100)  

set @target = '%searchstring%'          -- replace with string to search on

SELECT  

        so.Name,  

        sc.Text,  

       ...