Search results for query: *

I need to use a SELECT statement to find the Genus (animal-type) that costs the most to feed per 30 days. I've got the following query that gives me the average cost per Genus, but I need only return the ONE a_Genus_ID that costs the most to feed. I basically need GS.a_Genus_ID WHERE...

Dan, I've gotten this before. The SQL Server was unable to hit the PDC in order to verify the Domain User rights. Either there's been a change to your network security, local server security, or the PDC went down last night.

When the log dumps, is the log file cleaned out? Or does it still have 5.6 gb of data within the file? If it does, then the log isn't dumping properly. Check for an open transaction on the system which may be holding 5.6 gb of the transaction log open. If the log is cleared out each time you do...

I've either found a bug or I've gone insane. I have a select into statement that runs outside a stored proc but creates an open transaction that hangs within the stored proc. I'm on SQL 2000 sp3. It also runs if I put the statement into a variable and run it as EXEC(@sql). Inside the proc it...

We have locked our databases down to certain user created database roles. Now our problem is that when the SQL user is placed in these roles, they are unable to see any jobs listed under SQL Agent. I've tried several predefined server roles but can't seem to locate a lowlevel one that will allow...

We had this problem in 7.0, and 7.0's log shipping doesn't allow multiple standby servers. We wrote our own shell scripts that pick up the logs and apply them to both standby servers. When we went to SQL 2000, we heard a rumor that said it now allowed multiple servers, but since our own log...

Thank you!

I'm a DBA, so bear with me, I only know T-SQL. In DTS, I need to pump data from one machine to another based on a max(date) located in a table on the destination server. I've looked up Global Variables and I'm this far: 1) Execute SQL Task with Select Max(date) etc. with an output parameter...

Try looking in BOL for this: OLE DB Provider for Oracle under Accessing and Changing Relational Data. This is the detailed page I was referring to.

It's been a couple of years since I've done this, but I do know I needed to look at a white paper called: Accessing Heterogeneous Data with SQL Server 7.0. You can still get it from the Knowledge Base. This was a real bear to implement. Are you running 7.0 or 2000? BOL in 2000 explains how to...