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...

SP2 8.00.534

I've ran in both EM and QA. Same results from both.

I am trying to figure out what routine within the software is populating this field. To your question. I can pull the data up through EM and that is exactly what it shows no maninipulation. Is there some kind of switch on the database that I'm unaware of that could cause this? SELECT...

Results: ex_recpt_date datetime no 8

no, but only because all the rows in the tables that are >= 03/23/2006 do not have a time on them. If I change the query to a date that will return rows. (our case 03/22/2006) it will return those rows, but only those rows with the time.

I didn't write this query. It was generated from Profiler from one of our vendor supplied applications. Besides, that is not keeping the query from returning rows. Also, I have commented out the line that is holding up returning rows.

Now I am totally confused....I ran the same query against another database, similiar table, same column, same datatype and IT WORKED???? Here is my query select slot_item.* from item_master, slot_item WITH (NOLOCK) WHERE (slot_item.sku_id=item_master.sku_id AND slot_item.sku_id <> 0...

Still doesn't work.

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

OK, just for other's who might have the same problem as I did, here was the problem....HIDDEN CARRIAGE RETURN... I simply removed it from the string and now it works like a charm :-) Thanks for everyone's help.

I pulled the strings from the log file I'm writing to and did a compare with those, they did match. So if that's the case and they are indeed the same, why aren't the variables matching within the script?

I've tried just about everything from putting an extra \ so that it would take the next as a literal to doing =. I've also tried setting them as regular expressions to try and match that way. I'm just don't know what else to try. :-(

I trim the variables right before this step: strTogether = trim(strTogether) dbfile1 = trim(dbfile1)

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...