i think your trigger needs to be like this;

affect only the inserted records that actually also have [Transfered] = 'True';

your current trigger would affect all records being inserted at this...

something like this?

i need an anchor for the outer query, so i used the columnName;

your real table might have a queryId or something, i would guess, if you are testing...

fixed a syntax issue, and create the DDL for the CTE;

i got far enough to duplicate the one row issue before i ran out of gas...building the CTE took...

Eugene Elutin (11/27/2012)

---

ouch! i resemble that remark!

anyway, even with the caveats we mentioned, and...

what does locking queries mean to you?

preventing queries?

reuse the same queries?

encrypt queries or values?

you'll definitely have to explain, in much more detail, and preferable with an example query.

bcp.exe is a command line utility for importing and exporting to text.

it supports using a query, so you can construct a query that uses a WHERE clause that limits your...

boobalanmca07 (11/27/2012)

---

I am using two sql statements in stored procedure,

the two sql query is update and alter.

in some times i need to execute update query only,at that time how to...

i believe if a login belongs to the sysadmin group, and you create a user for the login in any database, the db)owner checkbox gets inherited as readonly ; that's...

runal_jagtap (11/27/2012)

---

Hi Friends,

i have asked to perfrom a task to create a New login & then provide the access rights to a particular DB..

I did it with no time 🙂

After...

ok sorry...

you can restore a database that doesn't exist yet.

in the object explorer in SSMS, you should be able to expand the server and see the Folder for databases...it may...

back and restore is the absolute fasted.

lets assume that a FULL backup exists for a given database on a certain server...if it doesn't exist, create one with copy only...

a bit o translation help from Google Translate

---

I want to do something programmed to monitor the connections of an instance of SQL Server 2008 R2 Standard Edition. But I would...

was google down?

explanations you should google yourself; specific questiosn are ideal for the forum.

http://stackoverflow.com/questions/999394/whats-a-real-world-example-of-acid

i use ihostasp.net[/url]

for some shared hosting, which also includes a SQL2005 database. You can connect to it via SSMS with a name, port schema (ie.server04.ihostasp.net,14430)

you can use MySQL as well...

one of the more obscure RESTOre commands can help you:

this command will present a row of data showing you the size and maxsize of the database, which is almost...