I can't read memory dumps, so my question is what is running at the time you get these errors?

Will have to look tonight, but wouldn't the is_disabled column equate to the locked value returned by the loginproperties function?

Not sure how to do it is SSIS off the top of my head, but if you use a SQL Task to do the work for you the following should...

Have you tried flipping the columns defined in your index? If you are looking for a specific provider, you should have that column first.

Interesting. I started thinking about how I got into working with SQL Server. Couple of companies back I was a programmer analyst working with COBOL and ISAM databases...

Brandie Tarvin (11/22/2011)

---

Kit G (11/22/2011)

---

But in Houston, and in Florida to a slightly lesser degree, 45-55 is the speed you go to merge into traffic going 65-75. Drives me...

atlancharlo (11/23/2011)

---

here i have a requiremnet to select multiple option for @selection user parameter.

declare @selection varchar(20)

declare @bank varchar(20)

Select @Selection = REPLACE(@Selection,',',''',''')

SET @bank=''

IF 'abc' in...

Please explain what you mean about data and files. I'm confused about what each has to do with the other. Are your application files changing through out the...

First, it doesn't really matter. If you always want those four columns at the end, specify it that way in a select statement when you query the data.

If I...

If you have already imported the data from Excel into SQL Server, it would help if you provided the DDL for the table you created (CREATE TABLE statement), some sample...

shannonjk (7/21/2011)

---

Eh no worries! Being a DBA rarely people actually see my face so I get it all the time with the companies I work with :-D. Ironically enough I...

LutzM (11/11/2011)

---

Done. Care to return the favor? -> buddies

TIA 😎

As a side note:...

philip.m.gaudet (11/11/2011)

---

Lynn Pettis (11/11/2011)

---

Have you logged into the server using the proxy account, run and saved the host key manually?

I had to do something similiar with a different application when...

Have you logged into the server using the proxy account, run and saved the host key manually?

I had to do something similiar with a different application when setting up a...

I know you got an answer, but I wouldn't mind if you provided an example of what you are looking for, say based on todays date of 11/11/11?