did you try to double up the bracket you're looking for?

'%[]]%'

We use scheduled sqlagent jobs to create the wanted types of backups at the desired time intervals.

So we use TSQL steps to actually create the backups.

We also use backup devices,...

FWIW I still follow the same guidelines as I used a couple of years ago when designing SQLServer hardware.

In dev we don't have the luxury of SSD or Tiered SAN.

In...

Books online has a nice topic on datetime http://technet.microsoft.com/en-us/library/ms187819(v=sql.105).aspx

According to this overview state 1 means your login (i.e. sa) is disabled.

Troubleshooting Error 18456

http://sqlblog.com/blogs/aaron_bertrand/archive/2011/01/14/sql-server-v-next-denali-additional-states-for-error-18456.aspx

you can download ( free ) the Microsoft JDBC Driver 4.0 for SQL Server drivers at http://www.microsoft.com/en-us/download/details.aspx?id=11774

oh, yes, indeed, totally forgot about DNS aliasses, however this being a client level issue, chances are it is a client side defined SQLServer alias.

SQL Server Configuration Manager / SQL...

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...