Error message: CryptUnprotectData Win32 error :-2146893813 These servers are primarily our clients - and i can't connect to any of them. Any ideas,...
Hi all, I've got a database in the test environment that needs to be refreshed from production. The permissions must NOT be brought across, but the...
Hi all, been meaning to ask these questions for a long time but never had the time for a bunch of threads, so I thought I'd centralise. Sorry if any...
Hi all, two problems, home page and Adventureworks. I have an installation of RS from a few months back, I can open Reporting Manager but have never...
Hi all, got an interview coming up next week, here's a few I've been asked in the past, just wanted to get some of my peers experiences! 1) What...
Hi all, I'm looking for an app that I can use to practice at home. I don't mind paying for it. Thanks, Jaybee
Hi all, I wanted to get some help with a personal project, with the dual purpose of practicing DTS. On one of my drives I've got a master folder...
Hi all, I've got a bunch of 2K databases ranging from 10Mb to100Gb in size, with corresponding complexity of DTS packages, numbersof logins/user...
Would be grateful to know what tools you've used, any best practices, gotcha's etc.... Thanks, Jaybee.
Hi all, I need to put together a project proposal for ensuring our database Operations are not unduly affected by upgrades from W2k to XP/Vista....
Query:SELECT CategoryID, Category, CASE substring(category, 1, 4) when 'fema' then 'female' WHEN 'Male' THEN 'Male' WHEN 'Gift' THEN 'Female' END AS...
I've already specified grid format and copied the entire dataset (Ctrl 'A', Ctrl 'C', Ctrl V), but the paste still ignores the column names and...
Hi all, I've created a report that rejects dates input in any format other than American, being a british organisation this is obviously an issue....
Hi all, UserName, Lan, AppSet1, Appset2, Appset3, OS, CPUMhz This is for a roll-out of applications across 3000 pc's, what I'm trying to achieve is...
Hi all, Installed 2005, but don't see the above DB listed in Mgt. Studio, and need it for the Tutorial! Also, can anyone tell me where to find QA or...
Any guidance for which one you'd use in what circumstances? I (should be!) writing a lot of ad-hoc queries in the next few months. Another question,...
Hi all, the reporting services checkbox was greyed out when I installed, and I got a couple of warning signs, about my hardware, and IIS. Do I need...
Deleted
Hi all, Background- I've got an academic package the following script is part of thatuses lookups to extract row-based sales data from Access,...
I know that @@version should yield whether something is: SQL Svr Ent Proc SQL Svr Ent SQL Svr Standard Proc SQL Svr Standard But..how could I...
Separate names with a comma.
