Right click the group --> delete.

Create a job, copy and paste your script into job step and schedule the job to run at time you like.

Don't forget change the 'varchar' in temp tables in your stored procedures, functions, user defined data type if you have any.

Which version and service pack of SQL Server you are running? Is a job created by maintenance wizard?

create table #T1

(table_catsysname null,

table_schemsysname null,

table_namesysname,

table_typesysname,

remarkssysname null)

insert into #T1 exec sp_tables_ex 'PROFILES'

The select into statement will create table for you.

Dynamically add Access database as linked server and use sp_table_ex.

Example from BOL.

C. Use @@ERROR to check the success of several statements

This example depends on the successful operation of the INSERT and DELETE statements. Local variables are set to the...

Try odbcping.exe. You can download it from microsoft website.

Have you tried -E parameter in OSQL.

-E

Uses a trusted connection instead of requesting a password.

Edited by - Allen_Cui on 05/27/2003 08:46:29 AM

select cast((convert(varchar(4), DATEPART( yy , getdate())) + '-' +

convert(varchar(2), DATEPART(mm , getdate())) + '-' +

...

quote:

---

DECLARE @ErrorsExist Int

Select @ErrorsExist = @@Error

---

@@ERROR Returns the error number for the last Transact-SQL...

Register MSDE 2000 instance with EM and change from there. If you don't have EM, you then have to change the registry.

Change key \\hkey_local_machine\software\microsoft\mssqlserver\mssqlserver\loginmode to 2.

Which version Crystal Report do you use? We don't have problem to run Crystal 8.5 against SQL Server 2000. I don't know why it doesn't work with MSDE 1.0. Can...

quote:

---

Connecting To serve007.hosted.servetheworld.net...Could not open connection to t

he host, on port 1433.

A socket operation was attempted to an unreachable network.

---