Have had couple of instances where we needed to rebuild tempdb...and several instances where our BCP just quits...with the following message:

SQLState = 08001, NativeError = 0

Error = [Microsoft][SQL Native Client]Unable...

Thanks Gail. Little bit off the topic. Reading through the book; I came to know about Total Server Memory and Target Server Memory. Couple of my instances has both of...

It seems like SQL server is leaking memory. I assign 30 GB to sql server memory. If I look at task manager, 30GB of Memory is used. What are the...

In the SQL configuration what should I put on max memory?

I'm on 64 bit VM. Running 2012. Have 64 gb ram.

'" -T -t"|" -r"" -c -q'

With the switch above, some files are getting generated in ANSI and some are generated in UNICODE...If I want just ANSI, what change...

with BCP logging, the following error message came out. Anything I could check?

SQLState = 08001, NativeError = 0

Error = [Microsoft][SQL Native Client]Unable to complete login process due to delay in...

Build on 2008r2 and then migrated to 2012

I see the notification service in 2005 tree...Do I need to move it to 2008 folder? If so, where do I need to move it?

Shouldn't I be seeing this service...

Where do i go see if 2005 sql notif service has been installed?

Thanks. Which field should I look for heavy usage of tempdb?

user_objects_alloc_page_count?

Is there any threshold to indicate heavy usage?

Thanks Gail. So, in my situation if I had used this dmv and figured out which query was using most of tempdb and killed it, I wouldn't have to restart...

The tempdb grows. In other words the drive where my tempdb files are becomes full. When I right click on tempdb, it locks up and I am not able to...

Trying dropping the user from the db and recreated it and still same error.

Sorry I was using the wrong DB context. Yes SID exactly matches.

it didn't return any record for that user from sys.database_principals. But if you go through ssms, this user has correct permisson to the db.