What do you mean 'it hangs'? Do you mean that you've selected the Taskpad view and you get a pop-up about a script error? If so, select View>detail (or something...

You have what is known as an 'orphaned user'.  Look that up in the BOL. In the Index tab, enter 'orphaned user', double click on the entry, then choose troubleshooting...

I would like to thank SQLServerCentral folks for working to help me out since I registered the first week in June and wasn't aware of the SSC code at that...

<quote>If you can ping by IP but can not connect to SQL Server by IP it is still Firewall issue<end quote>

Not so.  If you can use IP but not the...

Sukhoi,

You are asking Microsoft SQL Server people to answer a question about Microsft Access. While there is a forum for that on this site, it's mainly because some SQL Server...

Igor,

Curly braces are not used in SQL Server's TSQL.  They are normally seen in third-party applications such as Crystal Reports.  When you view the SQL for a Crystal Report, parameter...

<quote>Unable to ping the remote server (in a different domain).<end quote>

Well, there you go. You can't reach that domain and need to solve that issue.

Did you ping by the server...

Noel,

Good idea, but it doesn't always work. I have a third-party application (a major application where I work) that must have it's default database set for the 'user' database. If...

Even if you only do the Full Backup once a week (lets say Monday), it would be the same as my previous example:

Restore Monday's Full Backup, Wed's Diff, the Wed...

Every differential backup is of the changes since the last full backup.

Mon - Full Backup - 6 AM

         Diff with init - 6 PM

         Tlogs every hour

Tue - Full Backup - 6 AM

         Diff with...

What a shame I won't be there (casino night). I checked this site before sending my registration to my company for approval and there wasn't anything about PASS or using...

I have had this happen to me a couple of times.  I don't know why it happens sometimes but not all the time.

My solution was to create a script called...

First, do you have an account on the distant SQL Server?

Second, is that SQL Server instance using Mixed Mode or Windows Only Authentication?

Third, how are you trying to log in?

If...

<quote>I'm really thinking about putting together a series on interviewing… how to prepare, what to know, what not to know, etc. It seems kinda like a no-brainer, but the more...

I don't use maintenance plans, I script my backup jobs and run them as jobs. You can create one job, where each step backs up a different database. One of...