Not sure, I only use Server Editions of Operating Systems.

Think about it, you cannot do anything with Vista except development. So you could easily use Express flavor. You could use...

First thing that I would do is stop using a Cursor to perform a simple Insert of data into a table.

SQL Server is a set based database, if you want...

I did not see anything in the SQL BOL about this.

Andrew SQLDBA

Why not perform that in the stored procedure or the query. I think that would be the absolute easiest way.

onclick:if_IFCode('

ISNULL ( check_expression , replacement_value )

');

That would be much more flexible.

Andrew...

It would be easier to have a Windows Group setup and then make all the contractors a member of that Group. Within SQL Server, give that group access to the...

@@VERSION

Try that

You can find all kinds of great info in the SQL Books Online

Andrew SQLDBA

I think it would be much easier, faster and more secure to create an SSIS package, have that package scheduled, and then allow the front-end to fire off the scheduled...

You did not say if the flavor of database they have is Express. If not, then just use Enterprise Manager(SQL 2000) or SSMS(SQL 2005, 2008)

Do not install Express if they...

Yes, using ipconfig /all will give you the address of the private side, you need the address that the world sees. I use a Classic ASP page on the back...

Thank you to everyone for the wonderful ideas and thoughts about this issue

I greatly appreciate the code samples given by Jason, I will keep that one in my stash of...

David

To be able to search for a specific file extension, you need to specify that in the search criteria.

*.bak = Search for any file name with the bak file extension

*.mdf...

Thanks

Good point about the length of time, but we do not have fiscal year data in this database.

We can always pull the one that gets dropped from the script and...

I wonder if anyone ever uses the SQL Books Online?

Or as many have suggested, any one of the search engines.

It would have taken longer to login here and type in...

Dave

Have you ever made a backup of any of those databases that we are talking about? The Master, MSDB, or the Accounting Database?

SQL Server database is very technical, that is...

When you use the account package from MS, it does not use SQL Server, it uses a very cut down version of SQL, something like SQL Compact Edition, or something...