hi,

No the user has just executed select * from tablename.

but the data is still there in QA grid .

hope u all can help me

from

killer

HI,

The query was executed on SQA and the temp table is still opened.

Now how can i enter that data in  a table..

thanx for help

Hi,

FROM BOL

Allowing SQL Server to use locks dynamically is the recommended configuration. However, you can set locks and override SQL Server's ability to allocate lock resources dynamically. Increase this...

Hi Sushila ,

If u read my question then u will not find anything that i had written that i had deleted a system table.

Why u want to give another turn...

Hi ,

I am tranfering the data from Sqlserver to Text and Access Database.

I have log on permission.

from

killer

Hi Sushila,

I did not exceuted any megical statement just select * from tablename.

But still it did not get error my query just keep on executing.

from

killer

Hi,

In the sysjobs of msdb database there is a field named messages can increase the length.

the error messeges are written in the windows error log.

hope this helps u.

from

killer

Hi,

U must be running ur sql server with windows nt user so the error message come for rights.

BAsically the sqls server dont have that user  login so it do not...

Hi,

I think the user(login) dont have permission on sp_smdshell stored proccedure.

from

killer

Hi Remi,

It does not show any error but the query keep onn execution .

I have to manually stop the process and it shows odbc error.

From

Killer

Hi,

Below is the result of sp_helpdb.

tempdb     263.31 MB sa 2 Aug 24 2005 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=539, Collation=Thai_CI_AS, SQLSortOrder=0, IsAutoCreateStatistics, IsAutoUpdateStatistics 80

tempdev                                                                                                                          1 d:\program files\MSSQL\data\tempdb.mdf                                                                                                                                                                                                                           PRIMARY 1258432 KB Unlimited 10% data only

templog                                                                                                                          2 d:\program files\MSSQL\data\templog.ldf                                                                                                                                                                                                                          NULL 111200 KB Unlimited 10% log only

from

Killer

Thanx vik

from

killer

Hi,

What command u use to unzip a file from command prompt using winrar.I dont have winzip 9 command line i have older version 8 .X can u help me how...

Hi Faisal,

I already apologised for my mistake.

But yes this error occurs when u reindexing on less memory.So, U can increase ur max server memory.

Hope this helps u.

From

Killer

Hi,

Sorry that work on sybase.

just execute this

USE master

EXEC sp_configure 'show advanced option', '1'

EXEC sp_configure

what memory u set for indexes

 index create memory (KB) min  and max

from

killer