Hi,

Good discussion. Now, what is everyone's opinion on how it is better to compare dates, for exaple to select all records for today? There are 2 ways to do that,...

Here could be a solution. Use WMI script inside vbs file. WMI is Windows Management Instrumentation and is designed for this kind of tasks. Create a new text document, copy...

Nick,

Here is what you have to try. For example I created 2 tables:

BIGTABLE (FisrName,LastName,CustData) - this is a prototype of your production table

TEMPDATA (FN,LN,CD) - this is a prototype...

I would modify the question to specify what connection info has changed. Was it for the Report Server database or connection information for a report.

Hi Marcus,

It looks like you are going to use non-administrative login for SQL Server if you need to set up rights explicitly. A login that is a member of Administrators...

Nick,

Cursors are like recordsets where you are at a particular record, can analyze it and move to the next record. This is different from default SQL Result set that comes...

Nick,

I am taking a day off tomorrow but may login from home once or twice. I will be working Friday morning and then we have Monday off. I will try...

Nick,

You may pre-process if you have yesterday's file and something changed in it today, so you can parse text and find out what changed. How you just explained, it is...

Hi,

It is not clear what you would like: to add an updated row as a new record or update the existing record. I also don't know if the file contains...

And after you read tell us about it. Maybe a 1 page article. Is it free? What does it do? Is it for Windows or Unix? Does it have good features?...

Oh yes, sqlmaint. Dave is totally correct.

It is just the question was worded as "instead of db maint plan", and that probably send my mind away from sqlmaint.

Did you check Event Logs for the scheduled time or did you check the Job History? Is there any errors here? The question is, does the job attempts to start?

Marcus,

OSQL utility may run any reasonable T-SQL statement.

You have to be very familiar with BACKUP DATABASE statement to do it by the script.

The other idea is to use Job...

Hi,

Several years ago it was recommended to create Default, Constraint or Rule objects and bind them (SQL Server 7.0)

Now, with SQL Server 2000 it is recommended to use Deafaults and...

Nick,

Select type Text. Not Microsoft Text-Treber, but just Text, it is almost at the bottom of the list, The File Name textbox will let you then to select your csv...