Andy, David

I too will try to make ny code work after the holidays, the changes I made to it was to log the script into files without the user interface, compiled...

Hi Jan,

I tested it and it brings up the same wizard as if I would just open Excel first and then navigate to the file using File->Open menu. Thanks for the advise...

Andy,

This is a new installation from  CD given out during the launch event in Boston . It was advertised as a standard edition, not evaluation version. Select @@version returns:

Microsoft...

Andy,

I, as John had complains on the Microsoft.SqlServer.ConnectionInfo when creating an assembly from my own code incorporating your example. When I moved my DLL to C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies where...

Looks you have to fix both.

First, you can run sp_change_user_login to fix AR admin, see the link

http://msdn2.microsoft.com/en-us/library/ms174378.aspx

Then fix DBO on both servers by linking DBO to SA or other...

If you mean ASCII format then select the Text File driver in Export Wizard, if you mean other formats, then check if the driver for this format is installed.

If you are talking about adding additional columns from Table A to Table B then I would script Table A (without Drop option, just in case)  and copy the script...

Do you want to check in the database / log properties what is the Database Growth. If it fixed and there is no free space and the size increases due...

(This post was modified)

This is the advice if the database is not online:

Run sp_detachdb for your database, copy database files and try to re-attach to the same or different server. If it is a...

James,

same here: I did not word my comment about it too! Good thing you did it now.

Bluecats,

James is right. Do not use C$, create a share that will hold only...

Theoretically the last record should show the request to stop.

This will also work:

Copy the following VB Script code to Notepad, save for example as C:\CheckSQLStop.vbs and run either by itself...

With the access \\Computer\C$ there should be Both Share and NTFS permissions set appropriately. The difference between sites (assuming you mean Web Sites) may be that anynymous access allowed...

I don't think it is possible at all because there is so many types of variable length: varchar, nvarchar, text, ntext, new SQL Server 2005 XML data type, image and...

Brian, here are some ideas for PASS attendance justification

1. Active Directory is a Jet-based database.

2. ADSI which is Active Directory Service Interfaces has drivers that can be used to create linked...

You may want to read the following discussion on the subject, that talks about if a Windows login could be a member of more then 1 group with different default schemas in...