Are you asking about jobs scheduled for the SQL Server Agent (i.e. msdb..sysjobschedules?

If not, I think we'd need more information about your schema...

--Jonathan

As there's no such thing as a "delete constraint," I'm guessing that foreign key constraints on other tables preventing you from deleting the old values prior to importing the fresh...

quote:

---

I had a similar concern....

Backing up the database does not flush the transaction log and thus does not break the chain of...

quote:

---

I know you can move a table to a different filegroup in Enterprise Manager. How can this be done via a...

quote:

---

All right, got it, it works, cool, thank you so much!!!

Now, another thing that I just thought of, On Fridays, it needs...

Format the data in your front-end. If you're just trying to make it look pretty in QA, you could use the STR() function or CAST is as a decimal,...

select top 1 hostname, user_name(uid), program_name, db_name(dbid) from master.dbo.sysprocesses order by memusage desc

--Jonathan

quote:

---

OK, I dont know if I explained this right. This will not be a report that someone can click on, choose a...

CREATE FUNCTION dbo.udf_ListCols(@IndexName sysname)

RETURNS nvarchar(4000) AS BEGIN

DECLARE @List nvarchar(4000)

SELECT @List = ISNULL(@List + ', ','') + Col_Name

FROM Indices

WHERE Index_Name = @IndexName

ORDER BY Key_Seq

RETURN(@List) END

DECLARE @Index_Name sysname, @Table_Name sysname

DECLARE @sql varchar(8000)

DECLARE...

quote:

---

We have a new director of IT and he has a very strong Oracle background and worked for them at one point...

quote:

---

why sqlserver is using all the memory on the server?

---

Because that is what it is...

quote:

---

Perhaps I am missing something... What is backplane?

---

That's the connector board that the cable...