If your filegroup has 18 physical files, then the objects on that filegroup are spread across all 18 physical files. So your table will not just live on 1...

Try this

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/1d2cb76b-642f-4067-9667-aacdbc142f74/microsoftsqlserversqlclrproviderdll-ver-10xx?forum=sqlsmoanddmo

Strange that is not referenced in the query plan then as there is no mention of T659.

Can you post the output of the below when running it inside the databases...

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...