SQL IP Address (Virtual Server Name): NONE - correct, no remote access without an IP address

SQL Network Name (Virtual Server Name): SQL IP Address - correct, the network name is...

You're thinking in Visual Basic (or similar) not TSQL... 🙂

if @TransCode='TR001'

SET @p1 = dbo.AddFltAmount(@p1,@Flt_Amount) --here where i am getting error

--this would also cause an error end if...

Just select the Months option, and set the "Every" to 12, i.e. run every 12 months.

When you upgraded, did you update the statistics after the upgrade completed?

Not sure about 2008, but I know this was required after upgrading from 2000 to 2005, and not doing...

I may be oversimplifying a bit (okay a lot) but after the backup has finished reading data it circles back to the log and looks for any transactions committed that...

Can you explain in detail what you are trying to achieve?

I'm trying to fgure out why you would want them treated as a single column?

Just use a comma instead of a plus

CREATE INDEX IND_SEARCH ON TAB_HOCKEYTEAMS

(

COLUMN1,COLUMN2

)

As you can't stop your DBA's from viewing the data, then you may want to consider auditing what they do (using profiler). Then you can at least ask them why...

Can you explain exactly what you are doing, and exactly what you are seeing (and where)... e.g. if you are running the restore using TSQL, can you post the TSQL,...

No, the backup won't wait for DML actions to complete.

Assuming you're talking about full backups, your backup will reflect the state of the database at the end of the backup.

When...

mazzz (11/12/2009)

---

I pictured Jens Lehmann when I first read it, although have since seen he has an extra "n" in his name

(he's a soccer goalkeeper famous for shouting a lot...

What type of replication are you talking about?

Transactional and merge replication don't necessarily use BCP (apart from the initial snapshot).

I assume you are seeing the "restoring" message on the restore dialog withing SSMS.

If so, how big is the database? Don't forget the first part of the restore will be...

A few possibilities:-

Deletes leaving a gap where the row was.

Updates that change the size of the row, forcing the page to split

Inserts into the table that rollback before being completed.

Part...

Using transactions, you will get locks no matter what isolation level you are using (you will also get locks with an individual statement even if it's not part of a...