Viewing 15 posts - 1,021 through 1,035 (of 1,193 total)
Hi Zahran,
If you run IE as an administrator do the menus show?
Run into this myself in the past but I can never remember how to fix it 🙂
Cheers
Gaz
April 25, 2012 at 9:53 am
I don't think you can, as those files are the Visual Studio project files, they have no equivalent in Reporting Services.
I'd be looking at recovering from OS or File System...
April 23, 2012 at 10:05 am
Hi,
Don't think you can reference multiple fields in one case statement - you'll need a case statement per order by field:
ORDER BY [CASE ID],
CASE
WHEN @SortBy = 'A' THEN [CONTACT ALPHA]
WHEN...
April 23, 2012 at 9:47 am
I've seen it in the status bar on IE, when I forget to ignore it 🙂
April 20, 2012 at 3:43 am
Also to check - is the file referenced by UNC path?
And by network or admin share?
April 18, 2012 at 9:38 am
Hi,
sc_2111 (4/18/2012)
Hi,- we have made a configruation with witness so I suppose that if I take down the MIRRORED DATABASE on the principal the target should become active automatically.
Yes, if...
April 18, 2012 at 9:35 am
Good question, liked it. Never used WITH TIES but glad to know I remembered how it worked 🙂
Some familiar names on the list!
April 18, 2012 at 5:27 am
drew.allen (4/12/2012)
Gazareth (4/12/2012)
Think Foreign Key REFERENCES Primary Key 🙂
That's not quite accurate. The foreign key only needs to reference a unique key, it does not need to be the...
April 12, 2012 at 10:10 am
capn.hector (4/12/2012)
Sean Lange (4/12/2012)
But each constraint must have a unique name.good catch sean
Ditto, good catch!
Also, not applicable here, but good to remember/learn - you can reference unique keys in other...
April 12, 2012 at 9:15 am
As Drew says, you've got it backwards.
Swap the table & field names round in the SQL you've posted & it should be good.
Think Foreign Key REFERENCES Primary Key 🙂
April 12, 2012 at 8:22 am
Yep, SQL Profiler runs against the server & collects the queries run there.
If you look for the events RPC:Completed (Stored Procedures class) & SQL:BatchCompleted (TSQL class).
The TextData column will contain...
April 12, 2012 at 8:10 am
Hi Jerome,
The Rowversion datatype is a unique binary number, it doesn't record a date/time.
Is the column of this datatype or just named so? (May show as it's badly-named synonym, timestamp).
If...
April 12, 2012 at 5:15 am
The service account shouldn't matter too much.
State 11 indicates a valid login, but fails on server access for some reason.
There's a MSDN blog on it here, see if any of...
April 12, 2012 at 3:48 am
Viewing 15 posts - 1,021 through 1,035 (of 1,193 total)