You can see the raw transaction log by

dbcc traceon(3604)

dbcc log(1,-1)

dbcc traceoff(3604)

for dbcclog the first number is the databaseid (in this case master). This will however only display the active section...

One thing you can do, but this is a bit more labor intensive, is to create the tables without the identity properties. Then you populate it with data. Since you...

It is quite an interesting problem. It seems to do something with ownership chaining. The sys.sql_logins system view looks up items in the master database (master.sys.sysxlgns, you can see this...

It does not seem to affect table variables; the only place I've seen this is with multi statement table valued functions.

Andras

Hi,

your query is correct. For multistatement table-valued functions a hidden physical table is created in SQL Server, in the same database. This seems to be available only while the return...

Hi,

not sure I get you right .

With nvarchars if the input is Unicode, it is stored as Unicode (there is no conversion). Unlike with...

Hi Gift Peddie,

Luckily nvarchar uses Unicode to store characters, and Unicode includes almost all the characters from almost all languages; it has no problems storing any of the Greek symbols....

Hi Ahbi,

One possible problem is the way you insert the data into the table. If you have a nvarchar field, then you should insert the constant text data using the...

In SQL Server 2005 the owner of a stored procedure, view, function ... is no longer a user. These objects are now organized into schemas (schemata). During an upgrade process...

An alternative to dbcc checkconstraint in this case is if you aks SQL Server to check the trustedness of the foreign key when you reenable it. So instead of:

ALTER TABLE...

Hi Vinoo,

Short answer: No.

Long answer:

binary large objects, if they are not inlined, are stored on database pages that are different from the pages the referring row data is on. If...

Another tool that could help with your schema changes is SQL Compare Pro 6.0 by Red Gate (disclosure #1: I do work for Red Gate; disclosure #2: I'm the...

The problem is that

ALTER TABLE aaaa CHECK CONSTRAINT all

does only enable the check constraint, and it will still be considered untrusted from the query optimizer's point of view. If...