Search results for query: *

am in the process of trying to install 2008 using domain accounts for the services and receiving the error "the credentials you provided for the SQL Server Agent service are invalid. To continue, provide a valid account and password for the SQL Server Agent service" I am an administrator on...

I am doing a select from a datetime column where > '3/23/2006'. It is not returning rows that do not have a time. What is the deal? Returns - 3/24/2006 3:33:25 PM Does not return - 3/24/2006 Thanks in advance.

I have got a large number of log files that need to be deleted. Rather than do this manually, I would like to write a quick little script to do this. My question is, how does vbscript handle the deletefile command. I am worried about machine resources being consumed by a large delete. I...

I have written a script that loops through a list of SQL Server machines, then the databases inside of the server, then tables. Problem is that I'm currently just using a "use database" command to change to the next database, but for some reason it's not working. I get the message...

If I'm in simple recovery mode, when are the transaction logs truncated? Is it as soon as a full backup is done? Or do I have to specify a special parameter? Reason for asking: I had a transaction log grow to 13G about 2 1/2 hours after a differential backup. I'm trying to narrow down if...

Has anyone every used a tool called LogMon to monitor files? Here's my issue.... I use LogMon to tell when my daily import file has been placed on the drive. Once the file is there, Logmon is supposed to kick off my vbscript to run the actually import. Problem... It only works if I'm logged...

I am trying to make a list of 5 or 10 of the largest files on a drive. Any ideas where to start? Thanks in advance

I'm about to pull my hair out with this problem. I am trying to compare directories to make sure the are the same using the strComp. If (strComp(strTogether, dbfile1, vbTextCompare) = 0) then result: no match on C:\DB2\NODE0000\SQL00010 C:\DB2\NODE0000\SQL00010...

I have a few backups on a server that over the past week, have been running longer that normal. When I say longer, I'm meaning 7 to 8 hours before I kill the process. This db is about 30 GB's and the backup usually runs about 1-2 hours. I have checked disk space and memory usage on the...

I'm writing a script to move through a list of SQL Servers. I make a connectivity check on each in the list. My problem now is the error handling. If I cannot connect to the server, I want to write to a log file and move to the next server on the list, but I'm having problems catching the...

Dumb question... How do you concatenate the " into a string? Thanks in advance...

I am trying to query a number of linked servers using a recordset and receive the error below: QUERY: Set rsDBName = ConnectionName.Execute("select name from " & rsServers.Fields("sqlservername") & _ ".master.dbo.sysdatabases") ERROR: "Login failed for user...

Is there a way to run a stored procedure and then loop through it's results one-by-one? My case: run sp_databases (SQL Server stored procedure to return all database on a server) Then I want to loop through the results. So how do you execute a stored procedure with recordsets? Thanks in advance.

Does anyone know how to check db's to see if there's a need for a reorg? Thanks in advance

I am trying to figure out how to find a line in a text file that contains the current date and read from that line to the end of file. The file is a log file that contains a date and time on each line. So once I get to the line that has the current date, I want to start reading from there...

Within a script of mine, I'm kicking off an external process (defrag) and want to catch and handle any errors that the defrag might throw. Is there a way to do this? If external error call Error_handling ? Thanks in advance

I feel really dumb asking this, but I need some refreshing on how to set up dynamic arrays, how to populate them, and how to output them at the end. Can someone give me a link or two that shows how to do this. A little detail... I am reading in a file, placing it into the array and then want...

I am writing a script the creates a bat file and two text files used to ftp error messages. After the files are created (I see them show up in the folder) I am getting the error message: The process cannot access the file because it is being used by another process. when I try and execute...

Has anyone ever seen this error: "Object required: 'Run(...)'" I've search all over the net and can't find anything on it or how to fix it. This is what I'm doing: I am kicking off another script from inside of the main one and getting this error. The strange part is that the one...

I am trying to FTP error messages within a script instead of setting up the email(which is tooo complicated). Does anyone know how to do this? Thanks :-)