aamir.a4 (10/16/2012)

---

we're using SQL 2005 and running old VB 6 application. In this application we have a button that say "Create PO from this Quote" this button creates a New...

select into will make new table with the same column name and datatype, if you add false condition then only data schema will be copied without ady data

select * into...

Have you checked basic connections issue:

- ping by ip

- ping by host name

- telnet to sql port number

etc.

vamsi056 (10/16/2012)

---

i only installed Active Directory users and computers role ( to work with assigning user roles and permission from sql server to windows authentications), and i didnot installed DNS...

vamsi056 (10/15/2012)

---

Yes i read this article

http://support.microsoft.com/kb/2032911

i only have one Laptop , can i run sql server on a normal windows server ? i can but this makes me...

Wow, enterprise edition on laptop? I can understand installing Developer edition, but Enterprise which cost many $?

You...

You have incorrect conditions in where clause, that eliminates value which you want to see. Try this, and correct conditions in where clause to your needs:

SELECT *, dbo.tPeriod.PeriodDiscription, dbo.[tTimeTable2012-13].StaffID, dbo.[tTimeTable2012-13].DayID

FROM...

http://blog.sqlauthority.com/2010/11/13/sql-server-reducing-cxpacket-wait-stats-for-high-transactional-database/

http://www.mssqltips.com/sqlservertip/2027/a-closer-look-at-cxpacket-wait-type-in-sql-server/

Like they say, you should set ‘maximum degree of parallelism’ to lower number, or check how it was configured on SQL 2005 and set the same on SQL 2012

The user must have view server state permission, to grant user that permission execute:

GRANT VIEW SERVER STATE TO yours_user;

http://msdn.microsoft.com/en-us/library/ms179881.aspx sys.sysprocesses (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms186717.aspx GRANT Server Permissions (Transact-SQL)