tcronin 95651 (9/20/2016)

---

Going to do a upgrade from sql 2008 standard edition to sql 2008r2 on active/passive physical cluster. WHen finished wanted to upgrade the edition from sql 2008r2...

You can execute things such as:

select SERVERPROPERTY('IsClustered ')

exec master..sp_help_log_shipping_monitor

select *

from sys.databases

select *

from sys.database_mirroring

Sue

You have two different instances on your PC. You have a SQL Server Express instance and a localdb instance.

(localdb)\ProjectsV12 instance is created by SQL Server Data Tools (SSDT) and...

mw112009 (9/20/2016)

---

Please see attached. Any reason on the steps on how to fix this ?

The message is clear. But our team is confused as to why this user is getting...

joydev.dey 30829 (9/15/2016)

---

I have an mvc web forms web app, which uses report viewer control.

The app is hosted in two web instances.

When I try to access the application using using...

HookSqlDba7 (9/19/2016)

---

Thanks Sue. Your response helped. I may be making this too confusing but just trying to trace the SSRS Report Manager datasource login during report execution.

Sue: Data source credentials...

Since you said earlier that this is in a batch file, you need to look at checking the errorlevel in the batch file. See a similar discussion in this thread:

http://www.sqlservercentral.com/Forums/Topic1735929-23-1.aspx

Keep...

Krasavita (9/15/2016)

---

Hello I load from Pivot file which 89 mb and when created database it went significally high in 127 mb(estimated size) I checked in options of database, is that...

Which of the links above did you try? What were the steps you used and what was the result?

Sue

As Jeff indicated, osql is not a good thing to be using. It's on the deprecation list so you shouldn't be writing something new with it. Sqlcmd has been the...

imani_technology (9/15/2016)

---

I have the following statement in a batch file. However, how can I get a return code to let me know the SQL Agent job ran successfully?

osql -S...

It may not be running...that was the case we saw before. It just didn't log everything to the history.

Sue

There isn't a lot of difference with the different methods to shutdown SQL Server. The one exception being SHUTDOWN with NOWAIT. It's not a good thing and doesn't lend itself...

jerry-621596 (9/15/2016)

---

Great info! I ran that on both jobs and found that they only have one entry from when it started. There is no (Job outcome) entry.

I will check on...

I do get what you are saying and seeing - have had the same experience before. It changed the icon in the view after running the job again. I think...