Could you post the check for tempdb so we can put this myth to rest once and for all?

I see .

Alright... can't go against what they want .

Care to elaborate?

IF in QA >>

USE CorrectDatabaseName

or in the connection string of the application, you can specify the correct database with the option catalog (IIRC).

Check out http://www.ConnectionStrings.com

If you're sure that the table exists then try this :

Select * from YourUserName.TableName

to find your username :

Select USER_NAME()

Remove quotes around the tablename (unless you want to start messing with the quoted identifiers)

Does the table exist?

What's its real name?

No offense but that data is pretty easy to split (assuming the url is in a valid url format). And then the search engine wouldn't be too hard to...

Can you split the url into its parts.

protocol = https://

DomainName = http://www.SubDomain.DomainName

Folders = new tables with all the folders

FileName = Whatever.aspx

parameters = new table or string with the parameters.

That way...

Sorry but this is a presentation issue and it should be taken care of application side.

Full-text search uses like 'string%'. What do you need to search exactly?

No comment on this one from me, already cost us a user yesterday .

The session times out after a few minutes... always save the post before sending it away .

It should, but test this on a backup of the db just to be sure.

I need the table definition and sample data for all the tables involved and the required result with the data sent. I know it's a pain but that removes...