Are you refering to investment banking ?

Generally there are groups of data such as

Company data

Sector data

Trading data

Corporate filings provide a rich source of information , you could...

Are u able to ping the server , could u try creating a file with .udl extn and see if your able to connect using sal native client.I would double...

By design its implied that if your are an OS level administrator you would anyway have access to database files and services which could be used to bring the server...

Are u refering to forms authentication on reports server ?

http://msdn.microsoft.com/en-us/library/cc281383.aspx

All users would login as browsers but it would be the administrators job to ensure only relevant users have...

this article gives a good idea on where to place the membership db, since your tracking your own website users your membership database objects would need to be part of...

Buddy LOL 😀

hi

on a related note , i once suggested the below approach and wanted your input on if it was a good solution, naturally i am talking about a huge...

Details please ?? meanwhile u can run the sp minus the insert statement to check if its returning the required data, after that u can check for errors when trying...

declare @roomtype varchar(10)

declare @startdate datetime

declare @endate datetime

SELECT * FROM ROOM_PRICES

where startdate >= @startdate

and stopdate <= isnull(@stopdate , getdate())

and roomtype = @roomtype

while i personally use Try catch block

There are other ways of exception handling such as using begin tran with if @@error also.

Not at all , Infact I'll be glad if to know if theres a better way of doing this.

What i have setup is as follows

A local machine with SQL installed...

try using replace(newcol, ' ','')

are the columns char or varchar datatype , also have you tried ltrim , rtrim on the results provided the by the case statements

try querying sys.sysprocesses

I have a report which i use to check the health of my database servers, as a part of it i use xp_cmdshell to execute pings to the db server