That is a possibility. I will have to check with the developers. But I do know what there are an awful lot of text and image columns througout the database....

Are you just trying to make a copy of the database with a different name? If so you just need to RESTORE DATABASE FROM DISK = 'path here', etc.

Thanks for the reply. Unfortunately the database is set to AutoGrow with no restriction on size. I am just really stumped. I have never run into this.

Both good answers. Thank you. I checked the collation and setups and all seems fine there. And yes, I was thinking about recreating or altering the view. Just was curious...

Indenting and commenting is definitely the best way to go no matter what. But you could always look at an editor that helps you with things like this. I use...

You can create a user defined function that returns a table variable. You can also JOIN on a fuction. But you can't pass a table variable to a stored procedure or function.

Ahhh, sorry for the confusion. Ignore my last post. This silly thing *has* to be encoded somehow. If it were actually the "zip" source code there would be many invalid...

mkeast,

Thanks for all of your help. I was thinking of trying what you have listed above. But I finally heard from the vendor that creates this xml file and the...

Ok, I've got a little more clarity into this issue. The image field that I am trying to load from the xml file is in binhex format. A site that...

Thanks very much for the reply. I can handle using Bulk Insert and a format file. But after thinking about this some more I think that whatever is in that...

But what I need is a list of all users within a particular group. Running it without any parameters will not do this. Thanks for the feedback though.

You could always pipe the output from your osql command to a text file and then try parsing that for any errors that occur.

George

Grasshopper,

The requirement isn't going to change (as you said, for good reason). Was just wondering if I missed something. Thanks for your reply.

Bert,

The problem with keeping the password stored in...

Thanks for the link. I had come across this document while trying to find the syntax I need. I just haven't been able to figure out if it is possible...

Steve, thanks so much for your reply. I am guessing that you are correct although the Books Online state:

The database cannot be made smaller than the size of the model...