Execute sp_help sysdtspackages90

Shows us that the primary key has been defined on the following columns: folderid, name

That should uniquely identify the row - which should also uniquely identify the package.

The question I have would be why do you feel it is necessary to shrink the log file?

In most cases, this is due to not having regular transaction log backups...

It will only be a problem if you have 8 separate 1-core processors on the machine. I doubt that very much and would think you either have 4-dual core...

I wouldn't necessarily ignore the date - just understand that it is going to be unique based upon UTC time instead of local time. You still have to have...

Jeffrey Williams (8/17/2009)

---

And, after running those - what are your conclusions? Or did you just run them and paste the results here for me to interpret?

This was not an...

santosh.shrestha (8/17/2009)

---

Let us say we have a following table

CREATE TABLE Temp1 (

Aa varchar(10),

Bb varchar(10),

Cc varchar(10),

Dd varchar(10),

Ee varchar(10),

Ff varchar(10),

Gg varchar(10),

Hh varchar(10)

)

Now let us insert some thing in table so

INSERT INTO Temp1...

And, after running those - what are your conclusions? Or did you just run them and paste the results here for me to interpret?

This was not an exercise for...

I think we should really consider what the OP really wants to be able to accomplish. Most likely, they are looking for a way to have multiple default instances...

santosh.shrestha (8/17/2009)

---

I don't want to use SSMS. I want a query because I want to use it not only in MSSQL 2005, but may be in My SQL and Oracle...

Even with a synonym - you are going to have to same issues. The recommendation...

Elliott W (8/17/2009)

---

Paul,

Perhaps I'm being too semantic, I see default as if you install the product and do nothing else you can always count on the port being 1433 for...

Run the following and see what you get:

SELECT getdate(), getutcdate();

SELECT datediff(hour, getdate(), getutcdate());

SELECT dateadd(hour, 7, '20090817 08:00:01');

If...

Why don't you follow the advice in the error message and enable remote errors?

http://msdn.microsoft.com/en-us/library/aa337165(SQL.90).aspx

My recommendation would be to create a shared data source on the server and then modify your...

What doesn't work with the above? You can't just ask us to...