Paul,

Text is limited:

Books on Line:

text

Variable-length non-Unicode data in the code page of the server and with a maximum length of 2³¹-1 (2,147,483,647) characters. When the server code page uses...

Paul

Yes you can, just enter 'TEXT' as fieldtype for column 33 in SQL.

JP

Paul,

When you import the Excel spreadsheet in DTS when you come to the page of the wizard where it shows a table with your excel spreadsheet and the name of...

Hi

I'm not quite sure about what you mean with 'regiterd as local'. I guess you've registered it in SQL Enterprise Manager (EM) as 'local'. Just delete the server in EM...

Hi,

I perform the same routine almost daily and it never gets cut off. Have you applied SP3a or SP4?

JP

hi

form in access -> check the AllowEdits, AllowAdditions & AllowDeletions properties and the RecordLocks property

report in access -> check the recordlocks property of the report.

JP

Hi

A few things are easy.

1. building a trigger that inserts data in your table.

2&3. Passing the record to a webservice and wait is something you don't want to do...

Hi

Assuming you can start xp_cmdshell, try this:

xp_cmdshell 'net share'

JP

Philip,

I'm glad it's solved. I agree with Rudy, it's allways frustrating when someone messes up things and tries to keep it secret...

Like you, I never guessed it was in single...

Philip,

you're right. builtin\administrators is not required. But let's get back to the topic. You couold try to ste NTFS auditing on the folder in which you create the backups....

There must be some kind of process writing data I guess. If you cretae a sql profiler trace we you can maybe find out what's going on.

JP

Hi

In my experience the size of a tran log directly corresponds with the amount of data written. So a large log means large amounts of data written. (an index defrag is a...

Forgot to mention that we have the same kind of setup here. No builtin\administrator login.

JP

Philip,

Can you give some more details like:

- where do you store the backup file (local or remote)?

- Do you have a login for the SQL Service / Agent account ?

What's in the...

Why do a detach if you can do a backup? If you can afford the downtime, then it's OK.

I think (haven't tested it though) that you can make a...