You might need to set the WorkingDirectory to "U:\MEDTOX PROJECTS\zipping bak".

Edit: Put quotes around the path in your argument since it contains spaces: /C "U:\MEDTOX PROJECTS\zipping bak\compress_backupStep1.bat"

You aren't messing anything up. You just ran into a limitation of the provider being used, it doesn't support multi-valued attributes like MemberOf.

Here are a couple alternatives.

1. Redefine...

Since you mentioned the ROW_NUMBER function you might want to look at the NTILE ranking function too.

For example, to generate 4 groups based on col1 from Table1.

SELECT col1,col2, NTILE(4)...

Yes, there is.

In the Trace properties dialog go to the Events Selection tab. Make sure that DatabaseID is one of your included columns, then select Column Filters... in the...

Since the database itself was close to 4GB the 4GB FAT32 file limit came to mind. It would have to formatted as NTFS to support larger files.

What file system is the C: drive formatted with?

Can you create a file outside of SQL that's larger than 4GB? (using something like CREATFIL from an NT Resource kit).

Have you tried closing the connection in your catch block?

This article shows some of the steps a client might take when using mirroring:

Implementing Application Failover with Database...

The one thing that seems to be missing from your code is retry logic.

Here's an example of how you could use a loop to do that.

Dim iRetry as Integer =...

Walking through the string and stripping out the tags would be pretty straightforward too. This also handles a few common special characters used in HTML, like amp; and...

There may be other ways, but since the deployment manifest is an XML file you could just copy the original and edit. That would allow you to be selective about...

Since using that much space sounds normal for your situation leaving it at the largest size might be better option. Or, increase the frequency of the transaction log backups.

Have...

Another option.

SELECT t1.name, t2.name

FROM sys.tables t1

JOIN sys.columns t2 ON t2.object_id = t1.object_id

Cross post to: http://www.sqlservercentral.com/Forums/Topic478943-338-1.aspx

Response over here: http://www.sqlservercentral.com/Forums/Topic479104-149-1.aspx#bm479146

Cross post to: http://www.sqlservercentral.com/Forums/Topic478943-338-1.aspx

Response over here: http://www.sqlservercentral.com/Forums/Topic479104-149-1.asp

For the second part of your question it sounds like you need a single key value to group them by. Since you're looking...

Under Schemas, change the schema owner back to the original user or role, then drop the user.