double check the firewall has the needed exceptions to allow connecting to SQLServer/port using the tool of your choice

10.50.1600.1 is SQL2008R2 RTM

all higher numbers refer to service packs or cumulative updates, or the combination of both.

Is see in many companies that if they apply service packs/cumulative updates,...

Did you also publish a web service to consume e.g. the [northwind].[sales by year] stored procedure ?

trying to build my first Windows phone app and experienced the account doesn't...

A snapshot is a frozen copy of your actual database.

It can be used to provide users a read-only database state at a given point in time ( =create datetime of...

I wouldn't be surprised if your backup is being made by "others".

To figure that out, you could set up a trace to capture backup details.

You could even get a first...

How about some Powershell love to help with this: Export top n SQLPlans

it depends:

A scalar value function (SVF ) is called like

Select SVFSchema.SVF( value_to_be_used )

A table value function (TVF ) is called like

Select x.col1, ...

from TVFSchema.TVF( value_to_be_used )...

old thread !

but anyway, here's a fix for it: http://blog.armgasys.com/?p=259

Corrective Action

Disconnected all clients from the Principal database

Forced the Principal database...

What has been the goal of you dropping the windows login from these instances ?

You may want to change the job-owner for these jobs to sa and/or execute their steps...

can you double check these windows logins aren't having login auth via granted windows groups?

I would suggest to setup a bcp batch job using SQLAgent, providing the jobstep proxy account only with the needed authorisation to read the source data and write to the...

cls

$Path = 'c:\temp\'

$RefTs = ([datetime](Get-Date -Format 'yyyy-MM-dd')).AddHours(20) # 8PM

$RefTs

# select and delete files having last write time before RefTs

get-childitem -Path $Path -Filter '*.txt' -Recurse | Where-Object { $_.PSIsContainer...

- do you need to just copy the data once ?

you could use bcp.exe to do that.

- are you sure you really want to make both sqlserver...

how a simply clever trick just blows your mind.

I wonder how many people only read this Spackle once and really got it.

I just copied it to ssms and walked it...

I haven't used the builtin maintenance plan since early sql2000.

I use sql server backup devices. http://technet.microsoft.com/en-us/library/aa173665(v=SQL.80).aspx

Maybe that's a path you may want to investigate to overcome this issue.