http://forums.databasejournal.com Discuss anything related to Microsoft SQL Server 2005 en Fri, 10 Sep 2010 19:18:46 GMT vBulletin 60 http://forums.sqlwire.com/images/misc/rss.jpg http://forums.databasejournal.com http://forums.databasejournal.com/showthread.php?t=52246&goto=newpost Mon, 30 Aug 2010 19:40:41 GMT I'm a administrator new to development and I need to developo an App that will basically allow a user to drill down (thru some lookup tables in a database). i.e.

Screen 1
[] Ford
[] Chevy
[] Others
Screen2

[] Trucks
[] Cars
[] Mini Vans

Screen 3 will return a list of model vehicles base on what was selected in screen2.

Will SSRS be the perfer method or sharepoint or ASP.NET? ]]> Microsoft SQL Server 2005 kappa02 http://forums.databasejournal.com/showthread.php?t=52246 http://forums.databasejournal.com/showthread.php?t=52244&goto=newpost Fri, 27 Aug 2010 07:39:55 GMT Hi Guys.. I am going to restore a database using .Bak File. Is it possible to check the database table Vs Old BackUp tables. if find any changes in Current db (or backUp file) i Dont Want to restore the Db.. Hi Guys..
I am going to restore a database using .Bak File.
Is it possible to check the database table Vs Old BackUp tables. if find any changes in Current db (or backUp file) i Dont Want to restore the Db.. ]]> Microsoft SQL Server 2005 SaranSaki http://forums.databasejournal.com/showthread.php?t=52244 http://forums.databasejournal.com/showthread.php?t=52231&goto=newpost Fri, 13 Aug 2010 13:13:36 GMT I have a sql 2005 table with around 135000 rows which need to be exported to a Excel file (office 2007). Excel has limitation of 65536 rows. Please suggest if we can split data and then export in two files or two tabs etc. Also, if someone can suggest - we can write query SELECT TOP 65536* FROM tbl_Name What to write for the remaining rows? Thanks I have a sql 2005 table with around 135000 rows which need to be exported to a Excel file (office 2007).
Excel has limitation of 65536 rows.
Please suggest if we can split data and then export in two files or two tabs etc.

Also, if someone can suggest - we can write query

SELECT TOP 65536* FROM tbl_Name

What to write for the remaining rows?

Thanks ]]> Microsoft SQL Server 2005 ssingh http://forums.databasejournal.com/showthread.php?t=52231 http://forums.databasejournal.com/showthread.php?t=52230&goto=newpost Fri, 13 Aug 2010 11:27:22 GMT When excuting this query below

SELECT *
FROM OPENQUERY( ADSI,
'SELECT Name, SN, ST
FROM ''LDAP://xxxx.local,DC=AAAAA4,''
WHERE objectCategory = ''Person'' AND
objectClass = ''user''')

I receive the error message:

Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing the query "SELECT Name, SN, ST
FROM 'LDAP://xxxx.local,DC=AAAAA4,'
WHERE objectCategory = 'Person' AND
objectClass = 'user'" for execution against OLE DB provider "ADSDSOObject" for linked server "ADSI".


I've tried setting "Be made with this security context" But that didn't help and the login is a Domain account on the LDAP/AD server. What is that I'm missing or doing wrong? ]]> Microsoft SQL Server 2005 kappa02 http://forums.databasejournal.com/showthread.php?t=52230