Grant view to testuser will grant view permission on specific view. if you need the user to view all tables, then add him db_datareader role

In case, if you have created the new file in the same file group (PRIMARY), then you may stop the grow option on the old file and enable grow option...

Thanks Adi and gah. I wanted to have total count of transactions and with 210 count, 420 count. This is the expected results. thanks again.

Dear All,

Here, i need one more query. i want to delete nullified transactions. meaning, all rows with same (seqno and auth_type 1 and 2). So that, i will have only...

Thanks arun.

Thanks Paul. I just tried to run with fully qualified name. still the same 😉

Thanks Adi for the detailed reply. I really appreciate it. Thanks for your time.

Thanks Adi. If i change the parameter to datetime, it works fine. But need to modify all the VB and Crystal reports code (passing the parameter). Thats why i was...

Thanks Adi. If i change the parameter to datetime, it works fine. But need to modify all the VB and Crystal reports code (passing the parameter). Thats why i was...

Thanks Hari. It was very old code and hesitate to change anything. The change is a MUST now 🙂

Thanks again

Thanks Adi.

Try the sample code. it generates the same error

CREATE TABLE DBO.TEST (DAT_TIM DATETIME NOT NULL)

GO

INSERT TEST

SELECT GETDATE() UNION ALL

SELECT GETDATE()-1 UNION ALL

SELECT GETDATE()-2 UNION ALL

SELECT GETDATE()-3 UNION ALL

SELECT...

It looks like the physical path of the .mdf went wrong.

You must properly detach the db and move the...

If you still want to move system database to another drive, links are here:

http://www.takeabyte.com.au/2008/10/moving-sql-master-database-in-sql-2005/

http://blog.sqlauthority.com/2007/04/01/sql-server-tempdb-is-full-move-tempdb-from-one-drive-to-another-drive/

JYM

Yes, 'TO' is to move your data files or log files to different locations, when you restore database backup.

Thanks Lutz and Wayne. I am sorry for not giving all the required details at once.

I am looking for the results upto 10 seconds only. (even, if there is a...