What is the format of varable @DOB?

What about waitfor command in T-SQL? Sechedule job to run every one minutes. In the job, wait for 15 second and then perform the text file import.

You can't in Active/Active installation.

You can have only one default instance and the rest must be named instances and you don't have to install the default instance in the Active/Active environment. Both can be...

Thanks Antares686.

If you also have event id 2020/2021 in the application log, pls refer Q317249 too.

Do you configur OS with either 3GB or PAE and AWE for SQL Server?

...

I did see same problem in my server too. There is a regristry need to be modified. I will try to find it out.

Can you check the errors in system...

You can also use DTS or copy database wizard to transfer the logins and database.

I recently received same errors in one of my heavy usage SQL Server and contact HP SQL Server support. I was told this error can be safely disregared if it...

Run sp_grantlogin 'NT Authority\System' and then grant 'sa' right. It is case-sensitive.

From EM, goto logins --> choose the user and click property --> database access tab --> check permit on msdb --> database roles for msdb --> move the cursor to...

Create a domain group for those people with DBA responsiblility and grant system administrator role (sa) in SQL Server to this domain group in logins.

You need also to grant local...

You need grant permission to other users who are not the owner of job to access MSDB with database role 'TargetServersRole'.

You can set sp to run when SQL Server starts. What do you like to achieve?

Edited by - Allen_Cui on 10/15/2002 12:22:22 PM

Sybase runs on Unix platform and SQL Server runs on NT/2000. Some UNIX administration experience is required in order to administrater Sybase well if you want to apply Sybase backend...

Try either delete or rename the target table and run select * into targettable from originaltable.