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...

yulichka (1/6/2009)

---

Thank you for your help, but my db is set to full, what 3rd party software are you refering? When I run your code I get an error:Invalid object...

AFTER someone has already added it? maybe, but probably no. it's possible only under the following conditions:

database recovery model is set to FULL, not SIMPLE...then a third party log reading...

not possible with a single sql statement.... each table updated gets its own UPDATE statement, but it's not hard to put them together as a transaction. both tables can be...

I never try to store a total in a row where the details exist...instead I always use a view that does a sum() of the data in question. Since the...

yeah that's deeply annoying...I'd like to switch it back as well;

my alternative is to sp_helptext functionname/proc/view to avoid the dynamic sql style...but that's a bandaid, not a solution

rename the column.

add a new column with the right name and data type.

update the column to the value where the field was numeric.

update the columns that were not numeric with...