Szabo

This will give you the event id, the start time and the start time of the previous event.  You can play about with datediff to get the actual time difference,...

OK, so you're trying to run a stored procedure SP_InsertNewUser, right?  It sounds as if you've given your new user a branchId that does not exist in the Branches table. ...

JWA

( 63 / (63 + 1) ) * 100

John

I've never used Visual Studio.NET, but if you post the exact error message you get, somebody may be able to help.  In the meantime, could it be that the existing...

In the Windows search facility, type "*.BKP; *.BAK; *.TRN" (without the inverted commas) in the field All or part of the file name, then fill in the dates under When...

JWA

Buffer cache hit ratio is a percentage, whereas cache hit ratio is a simple ratio.  So a cache hit ratio of 63 means, as you say, 63 cache hits per...

John

Multiple filegroups are good for a VLDB, since you can back up individual filegroups rather than the whole database, making your backup strategy more flexible.  You will only see a...

Product oriented?  Sounds like management speak to me, and I don't think it translates into anything that you, as a DBA, would want to touch with the proverbial barge pole. ...

Jeff

Yes, so long as he only wants to do this on the identity column.  His original post was a little more general than that.  We await the explanation...

John

David

Make sure that the columns in the tables in your subscription database have exactly the same data types as those in your publication database.  It sounds as if you're trying...

Greg

I think that if you have migrated the databases of existing applications, then you are bound by the design of each application.  For example, some applications have an application server...

Bhushan

The point of clustering is if a resource (for example SQL Server) fails on one node, it stops and continues running on another node.  Therefore you shouldn't find yourself in...

Simon

According to Books Online, sp_changedbowner "Changes the owner of the current database".  So the answer to your question is no if you want to use that stored procedure.  However, have...

You could probably get an ugly solution using dynamic SQL and the information_schema.columns view, but I wouldn't recommend it.  One of the many reasons I wouldn't is that if you...

Walter

Not tested, but can't be far off... You just need to dispense with the SELECT. Also, I've changed your old-style join syntax to the ANSI standard.

update tbl1

 set col1 =...