You will need to ensure that your connection strings have the application name parameter set in them to do it, then you can check the sys.dm_exec_sessions DMV to get out...

Something like this?

declare @date int = 20140714, @hour int = 4

SELECT DATEADD(HOUR,@hour,CONVERT(DATETIME,LEFT(@date,8)))

What type of object is T659? Is it a view or a table, as that object isn't in the plan which leads me to think its a view which...

I would first check to see if it is actually a trailing space that is at the end of the string, as it might be a hidden character and therefore...

Every companies prices will be different to some extent due to the reseller they user and the margins they add to the quote.

For my open value program a 2 core...

Ratheesh.K.Nair (3/27/2013)

---

I have admin previleage in that machine..

I stopped sql server and agent and started sql server using net start mssqlserver -m

when i tried to connect using SQLCMD -U domain\user...

Add yourself as a admin on the windows host, start SQL in single user mode, then use SQLCMD or SSMS in query mode only to add in your windows account...

Incorrect spelling of the server name

Is the server online

Can you connect via SSMS

Have you enabled remote connections

Probably not, Google to see if Access supports the ROW_NUMBER() ranking function.

shathaway 77080 (3/26/2013)

---

I am still basic newbie to sql(1 year) how can I create accounts and permissions on a db from dos batch file? If you have a...

Get a new certificate then install it.

You can't

SQL needs to restore the database as it was at the time of backing it up.

To do what you need to do add another script to your batch which...

Also I would check your local computer keyboard and language vs the servers keyboard and language.

E.g English British and English American the keys are in different locations eg Shift+2 in...

If you want to control SSRS in SSMS then you will need to downgrade to SSRS2005.

As for why, unsure, I would see if there is a connect article on it...

You cant do what you want to do in SSMS you need to do it via the web page.