Ge,

the indexes which are greyed out are most likely created for Primary Keys and Unique Constraints. You can't move those, you must drop the constraint and then re-create it on the correct...

Shama,

I once had a similar issue after changing the startup parameter for the SQL logs. Make sure that the parameter is set correctly and that there's no space or offer...

Ashish,

using sp_procoption you can set a stored procedure to execute at startup. So just create stored procedure which would add you user to the tempdb and then set the option.

Another...

Nelson,

by the way the expression you tried works once you place quotes around the values for the borderstyle.

=IIF(Fields!c3.Value<>0, "Solid","None")

Markus

Nelson,

why don't you use the Visisbility property with an expression like this:

=IIF(Fields!Col1.Value = 0, TRUE,FALSE)

This hides the cell if it's value is 0. Changing the border style would still display...

SQLORACLE

sorry if I offended you but I'd like to make two comments.

First of all your article only talks about system databases, while the original post never mentioned these.

Second I've seen...

Nelson,

I'm not sure what you're trying to achieve but it should be possible by using an expression. In the Properties window change the value for the cell borders from the...

The indexes with a name like "hind_" are hypothetical indexes left over by the index tuning wizard. There is a KB article about it http://support.microsoft.com/kb/q293177/, but the problem should...

You can try using some scripts from this article http://www.sqlservercentral.com/columnists/jgama/sqlserverpasswordauditing.asp

or download NSSQLCRACK from http://www.nextgenss.com/products/database-security/ngs-sqlcrack.php. But be aware that if your password is more than 6 characters long it...

Ganapathi,

somthing like this should work:

Update

myTable

Set col1 = Col1 + 5 -- Put your new value here

where Col2

Michaela,

when using CLR the placement of the dll is only important while loading the CLR assembly. Once this hace succesfully done you can remove the dll. So even on a...

Patrick,

you could use the OPENROWSET function, but if you need to do these type of queries regurlarly I would prefer a linked server.

Markus

chidd,

no, you can't find the name of the machine or user unless you're table design tracks them. I always advice to have a column changedate and changeuser, especially when using...

Rob,

the query is fine and what your colleague told you is nonsense. I'm pretty sure that if you use Profiler and run a trace you will see the query completes...

Sorin,

DBCC TRACEON(1118) will turn on the traceflag for just the current

connection, whereas including the flag as a startup parameter will apply it

to ALL connections.

Anyway I'm not sure I would use...