Thank you for your documents.

after taking backup of single table in a file how can I restore that file in a database ?

hi,

Below error is occurring while executing bcp -

C:\>bcp export1.dbo.tab1 out new.dat -T -c

SQLState = 08001, NativeError = 17

Error = [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or acc

SQLState...

User does not want to create another database. And if it possible with BCP can you please brief it, I never used this utility. How can I use this BCP...

Table have 33 million rows.

Hi Gail,

My boss told me to validate transaction log file, i just could not understand him. I don't know what exactly he wants me to do with transaction log file,...

Hi Mohan,

In my case log file is 516 gb of initial size with enable autogrowth. We have a maintenance plan to rebuild index but i noticed, after completion of rebuild...

Hi Mohan,

Please refer your old thread.

But as per my knowledge there is resourcedb in SQL 2005 too. If you go default data directory you will find mssqlsystemresource.mdf and mssqlsystemresource.ldf. I think these two files belong...

I used DBCC command manually to defrag the indexes and it worked for me. Thanks all.

This stored procedure will fix the orphaned users, if i am not wrong but what about the permissions and rights of those database users which were on production and now...

No, we do not have any shrinking task too.

No tables are not heaps.

Yes, all page counts are >1000.

FG1 is primary one.