Pablo,

Sorry, that's my fault.

"file" is a reserved keyword, hence the syntax error. Try this instead.

create table #imported_files

(

subdirectory varchar(256),

depth smallint,

isfile bit

)

insert into #imported_files exec master.dbo.xp_dirtree 'c:\',1,1

Once you're done processing the...

Good article. 

One thing that should also be taken into account when considering replication is that comes with a greater management overhead than log shipping.

Log shipping is far easier to...

Problem is that it doesn't stop them from editing the stored procedure, it just encrypts the stored procedure text.  They could edit the stored procedure and replace it with completely...

Hi,

Unfortunately, you cannot restore system databases to a server with a different version to the one from which the backup was taken.

You could just script the jobs and apply the...

The original record(s) will be in the deleted table.

When an update is performed SQL Server deletes the original record and inserts a new record so you'll find the original record(s)...

Yep,

That is what I was going to suggest but I'm always a bit reluctant to advise other people to update system tables.  I'm happy to do it myself but it's...

Hi,

There is no function as you described but there are a couple of ways you could achieve the same result.

You could examine the inserted and deleted tables.  If there are...

Yep,

it's a mess alright in SQL 2005.  As far as the GUI is concerned, whoever designed the GUI around security must have purposefully tried to design a system that required...

I see,

I haven't use SQL2005 Express but doesn't that come with something called SQL Express Manager?  It's a cut-down version of Management Studio from where you can create a database...

Matthew,

Sounds like you may have a bad backup file.  Check the error log and see if you have any more detail in there.

The chances are though that you have bad...

Hi Madiha,

Restoring msdb is fairly straight forward and you should only need to worry about stopping SQL Server Agent.  Nothing bad will happen if it's running - it just won't...

Hi,

Unless you are already controlling all data manipulation with the use of stored procedures your best bet would be to use a trigger.

Now you have to decide what you want...

Hi John,

The fact that this is inside of a cursor is more than likely where the performance drain lies.

You have to figure out a way to NOT use the cursor. ...

Hi,

no, it is not possible.  You can only include a select statement in a view.

If you're looking to use the SET statement then you want to perform an update so...

Hi,

no each named instance will use the same IP address but will have a different port number.

Connecting to the SQL Server is done by using the servername\instancename.