This method should be faster

SELECT rows FROM sysindexes

WHERE id = OBJECT_ID('YourTableName') AND indid < 2

I use MyGeneration for all my sql code generation.

http://www.mygenerationsoftware.com/portal/default.aspx

not sure about the comparison part, can you explain a bit more what you need?

Right Click on the column in SSMS and click rename..

Yes SSIS would be able to dp this nightly, schedule it as a job to run each night.

The best/easiest place to start would be open a new SSIS project...

Not sure if it is possible to encrypt a proc.

Why do you not use security in SQL, and deny the user the right to view the procedure?

maybe the rows were deleted

When you use a function like this then it will be called for each row that needs updating.

It would be far more efficent if you put the values that are...

SSIS would be perfect for this task.

Or you could try a backup/restore

A conditional split would be used for this,

You can do a look-up transformation against the target DW and check for the row, and then split out the data depending...

Could possible be a SQL injection attack.

How are you acessing your database?

are you using Stored Procedures or Inline SQL?

1 Lakh = 100,000 in the Indian numbering system

as mentioned you can not do this directly, either use linked servers or SSIS

MS does provide a driver for .DBF files..

TRACEY (1/16/2009)

---

I don't see your steps in the post ?

Yes i don't want to spend hours on it he he.....i got three instances of system db to move around...

nabajyoti.b (1/16/2009)

---

If so...

could you please let me know the options to choose while i install the sql management studio without installing server.

Also, please note that i am intendint to connect...

this is the method that I use and Microsoft recommends;

http://msdn.microsoft.com/en-us/library/ms345408(SQL.90).aspx

How is the Access application connected to the SQL server?

Have you linked the tables into Access ? or are you using a connection string in the code?

or another way?