I would try to use Upgrade Advisor first....however, I'm not sure it will work with SQL Server 7.0. Check this link out..

https://msdn.microsoft.com/en-us/library/ms144256(v=sql.105).aspx

That (if if works for 7.0) will let...

Lynn Pettis (4/24/2015)

---

jonathan.crawford (4/24/2015)

---

Steve, my brother is getting hitched on the 4th of July weekend in Breckinridge. I'm not sure we're going to be able to make it, but assuming...

There's only four options I can see:

1. include the date value in the statement.

2. have a for insert/update trigger(s) that will add the date

3. have an after insert/update trigger(s) that...

Look into these MSDB roles:

SQLAgentOperatorRole

SQLAgentReaderRole

SQLAgentUserRole

I've listed them from highest permissions to lowest - if you grant one permission, the one(s) under it are automatically granted.

Those will allow a user to...

SmilingLily (3/18/2015)

---

One of the database that I monitoring is showing the .mdf file full.

Recovery model of that database is simple.

what is the best way to handle it?

Am...

You say you can't use SELECT * FROM viewA. Have you tried listing out the columns? Let's say the view has 5 columns and column 3 is restricted.

SELECT...

Real World....kinda...

Let's say you run a site similar to this one. You need to update each user's number of points. You could just query the database for each...

SQLAssAS (3/6/2015)

---

One of those anoying little things..

UPDATE [Staging_TABLE] SET Data_clean = REPLACE(Data_clean, '||','"')

WHERE (Data_clean like '%|,||%') and Data_clean not like '%|,||,|%'

|,|text|,||,|address1|,||Housename" Address2|,|

I am trying to replace the || with "...

In SQL Server, sometimes user logins get orphaned. I took this cartoon to be that the 'users' had orphaned logins and were unable to access the data that they...

Eirikur Eiriksson (3/5/2015)

---

SQLRNNR (3/5/2015)

---

Sean Lange (3/5/2015)

---

Sioban Krzywicki (3/5/2015)

---

Sean Lange (3/5/2015)

---

Brandie Tarvin (3/5/2015)

---

SQLRNNR (3/5/2015)

---

dwain.c (3/5/2015)

---

Is it just that it's been so long that I haven't posted one, or does the Article...

You may have multiple 'connections' open to the database. One that trips users up is to expand the list of databases, click on the database (one connection), and then...

Sioban Krzywicki (2/26/2015)

---

Grant Fritchey (2/26/2015)

---

Brandie Tarvin (2/26/2015)

---

Jeff Moden (2/25/2015)

---

Brandie Tarvin (2/25/2015)

---

Need some advice, all. I'm about to rewrite a novel of mine and I need references for research. My protagonist...

Jeff Moden (2/25/2015)

---

SQLBill (2/25/2015)

---

Jeff Moden (2/24/2015)

---

Just curious... does anyone use RedGate Compare to promote code from Dev to Staging to Prod? Looking for both positive and negative comments on...

Brandie Tarvin (2/25/2015)

---

Need some advice, all. I'm about to rewrite a novel of mine and I need references for research. My protagonist (the star) is humanoid but not human.

I...

djj (2/25/2015)

---

Currently reading "Treason" by Orson Scott Card. The book talks about humans that have different abilities. May not be exactly what you are looking for.

Interesting forward as...