kyle.doouss (11/29/2011)

---

Yes I did but I could not work out how it all went together.

Do you create a note file .fmt. From the bcp do you then put -f...

It's a known behavior.

The grantor (or the principal specified with the AS option) must have either the permission itself with GRANT OPTION, or a higher permission that implies the permission...

Did you click on the URLs I provided?

Denesh Naidoo (11/29/2011)

---

Hi All,

I see this when I run sp_who2 'active'

I see a SPID doing an UPDATE...and it shows it's being blocked by another SPID. If I then do a...

mamidimahesh (11/29/2011)

---

I get below error when I restored productin db to my environment. Can someone help me how to resolve this issue

Could not connect to server '<<ServerName>>' because 'sa'...

rashid_alavi (11/29/2011)

---

hi All,

I Dont want to change on the DB , i want to have that display as YYYY/MM/DD when i want to generate reports for the application reports, the...

Are you talking about Shared Locks?

Shared (S) locks allow concurrent transactions to read (SELECT) a resource under pessimistic concurrency control. No other transactions can modify the data while shared (S)...

kyle.doouss (11/29/2011)

---

I am using the following to export a query in the a tab delimited file. I am having a promblem with the format it porduces.

If you open it up...

Nice Pointer Jo 😉

Hmmm... I wanted to help you in a way that might helpful for long run i.e. understanding CTE & sub-queries. It seems you want short term solution (spoon feed).

No...

Then you'll have to accept one of three things:

1) Keep this testing server in simple mode to avoid necessary transaction log backups.

2) Don't backup daily and accept the fact that...

SPAM!

You are new to SQL Server so I am providing few more information on sub-query.

Subquery Rules

A subquery is subject to the following restrictions:

•The select list of a subquery introduced...

Try it with CTE...

Syntax:

[ WITH <common_table_expression> [ ,...n ] ]

<common_table_expression>::=

expression_name [ ( column_name [ ,...n ] ) ]

AS

(...

Please verify DBCOLUMNFLAGS properties for OLEDB provider.

It should be 'DBCOLUMNFLAGS_ISFIXEDLENGTH = false' for VARCHAR.