I don't know if it's just me, but SSC has been having some blocks of time where it's very slow recently. I had one this morning where it took...

andrew gothard (8/25/2015)

---

Ed Wagner (8/13/2015)

---

I feel your pain. Baan's tables were named using a multi-part...

1. dateadd(day, 0, datediff(day, 0, getdate()))

2. Create a new database from a backup file. Give it a new name and change the physical and logical filenames as well.

3. Find all...

Very good question. Thanks, Steve.

Eye

Can you use SQL*Plus to connect to Oracle and select from the views you're trying to query from SQL Server?

You're getting an ORA-00936, which tells me that the error is...

Grant Fritchey (8/24/2015)

---

Jeff Moden (8/24/2015)

---

I thought you just wanted commands. As for "top scripts",...

Rocky

Lynn Pettis (8/24/2015)

---

Oh, and welcome to the Water Cooler. There is a Tent in the Desert if you need it. We sometimes have parties there as well. ...

Mouse

Pistol

rajeshjaiswalraj (8/22/2015)

---

this is my test server which i m using in my local system.. I m using gmail for this... please help me on this.. I have 6 Instance running...

Lemon

I'm interested in these reasons the application needs the db_owner database role.

I'm with Lowell on this one: revoke db_owner and grant execute, db_datareader and db_datawriter.

The login should have the...

What you include in your ALTER TABLE depends on what you want for the the new column. At the minimum, you'll need:

alter table schema_name.table_name add column column_name data_type;

However, you...