Matt that's interesting, i didn't know about WITH SCHEMABINDING to a function...

does the results have to come from a SELECT statement in order to be deterministic?

I'd assume that an IF...

I'm watching for better answers, but this is how i understand it:

suppose you had a table with every address in the united states...200 million or so.

any search is going to...

i would not put the counter_id data in the table...instead i would make a view which had the value you were looking for:

[font="Courier New"]

SELECT      Row_number() OVER (PARTITION BY x.chk_no ORDER...

I'd tripped over the same issue previously.

ok, really you only need to search columns that are of type varchar,char,nvarchar and ntext....you obviously wouldn't need to search a numeric field for...

truncation implies that x number of characters of a string are not being saved....that wouldn't happen to a number(int for example)

do you mean decimal information? the definition for your columns...

i don't know if you'll find it;for the indexes on all the PK's and UQ indexes, you can find it because the creation date of the PK and it's index...

there is an example in this forum post which has my example:

creates a database and two example roles: one that can create and alter tables, and one that can just...

well first you need a proof of concept: can you find a char(0) in a field...actually, you don't need to search every column,

but rather every char, varchar, nchar and...

see the thread here:http://www.sqlservercentral.com/Forums/Topic326235-5-2.aspxit's got a complete explanation on the flags., as well as a code snippet to plug in your status and get the results.

as long as the logon exists, you could then add lots of users to the same logon. once the logon exists, you don't need to throw the password around...is that...

while you were in master, you should have added a login to the server, and then in your database, add a user to that login

here's a simple example, where I'm...

urgent? if you had read the chapter or listened to the lecture in class....

in SQL 2000, after the fact, most likely you cannot find out.

if you had profiler running a trace, you can go to the profile....but unless you set it up and...

So as Administrator, it can access the folder with Read/Write permissions, but as it's normal domain rights it can't...I think it goes back to Security permissions on the Folder.

If the...

you need to track changes in the TEMPDB? maybe you mentioned the wrong db?

Are you sure you need to do that? all the tables would get dropped at the...