We have moved all the objects from SQL Server 2005 to SQL Server 2008. its been a month now had stopped all SQL 2005 services. We are not using SQL...

Can you confirm the Data Type of the field DateID?

It excatly the reverse way. I mean its just the same way you have done it for Sucessfull notification, just a change in this is you have to add a...

The good way of manupulating millions/ billion records is to manipulate it in batch say batch of 1000 records / 200 records. Also avoid using the cursor, as it holds...

you can also generate the script from GUI...

GRANT SELECT ON [dbo].[MyTable] TO [MyRole]

You can approach for SQL Server Integration Services to migrate the legacy data from Access to SQL server.

There are different ways of migrating database to new enviornment. MSDN has nice article which will help you to plan your upgradation.

here is the link...just go-through it. If not understood...

I guess creating the maintenance plan with maintenance cleaup task would help you in a better way rather than writing a script and scheduling the Job

for a while it was solved but i guess it's not. I have only 2 GB of memory available on the server.

Nice answer Paul :). Thanks for your solutions.

I guess I named it as an associative table between two tables. The values are correct.

yeah this is the funny situation where i am stuck now...;-) any solutions to get out of it

to make example simpler ....

KeyID comes from entity "Key"

RefID comes from entity "Ref"

Key can have mutiple Ref and Ref can be linked with multiple Key. Its M:M relationship.

I hope now...

See its simple the table structure i have mentioned here is just an association table. The query which i want write to find identical keyID is from the same table.

For...

We are not using stored procedures. Dn't ask me y:w00t: