You don't edit them they any wizard. you modify them using T-SQL Statements. All you are doing is storing the data in a table. you then use a variable to...

Only advise that I can give, is get rid of all the Pearl and Unix stuff, and use SQL scheduler. No need to monitor to see if a job is...

The SQL Books Online have some great tutorials on SSIS, SSRS, SQL Server, SSAS and some more things.

There are also some great sites if your Google for them.

Andrew SQLDBA

The job never completed, so there will be no history. The table that stores the info about the job is still indicating that the job is running. You can update...

I honestly am not sure. I have never used the Express flavor. I am thinking that it is in the latest version that you can download from MS.

Andrew SQLDBA

Does the table have a date stamp column? Or something that would indicate a time or a date of when the row was inserted?

If not, then you may be the...

Gee Zee

By "tools" I am assuming that you mean the SSMS app, Books Online, etc....?

I have never had a problem using any Drive that I want. But none of my...

You can now use SQL Reporting Service, and get rid of Access totally. You wan to see some wonderful slow downs, then keep using Access to access the data in...

That is all the Access knows how to pump over to SQL. It does not know how to move the queries and created stored procedures. I would highly recommend going...

I am not seeing that you have actually created a user account and a database. Installing SQL only installs SQL. You need to create a database, and then a user...

What type of .NET app? Web App, or Client Server App?

What does the connection string look like?

Thanks for the Article about Remote Connections

Andrew SQLDBA

For one thing, I do not see that you are specifying the name of the box that the SQL instance is residing.

And second, you should Never, Ever use the sys...

Yes, it should work better then Windows Auth, since you do not have Active Directory(I am assuming). Using SQL Auth, it more simple when you are coding something like that....

This is what I use, and have no problems at all. I use the web.config file to store the connection string. I encrypt it normally.

<connectionStrings>

<add name="<WhatEverName>" connectionString="Data Source=<ServerName>\<InstanceName>;Initial Catalog=<DatabaseName>;user id=<SQLUSerName>;password=<Password>;"...

A column cannot be NULL, you must have a name for the column or it does not exist. Are you sure that you mean column, and not a row?

If you...