|
|
|
March 2003 May 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Sort performance with Access project form Posted by TLD at 1/26/2007 7:41:01 AM The sort performance of my Access form is very slow. The datasource is a
stored procedure. The sort is changed by setting the OrderBy property.
Please suggest means of speeding up sorts.
If this is the wrong user group, please point me to the right one.
Thanks....more >>
Add Login Posted by Rogers at 1/24/2007 4:58:48 PM I want to add login in SQL Server 2005 through Query Analyzer and grant him
System Administrative Role through query analyzer, can any one help me out?
...more >>
Msg 20009, Level 9, State 0, Server OpenClient, Line 0 Posted by samir at 1/23/2007 8:18:10 AM i can't connect to MS SQL 2000 server. Please advice. I am running
this from command line. Apache2, PHP5, Ubuntu Dapper.
0> /usr/local/freetds/bin/tsql -H [server] -p 1433 -U sa -P[password]
locale is "en_US.UTF-8"
locale charset is "UTF-8"
Msg 20009, Level 9, State 0, Server OpenClient, L...more >>
Certification Posted by Rogers at 1/17/2007 2:04:26 PM I am just wondering if I wanna upgrade my MCDBA 2000 certification to MCDBA
2005 then which exam I have to clear ?
Thanks
...more >>
Ad hoc query running crazy slow. Posted by DARR at 1/16/2007 4:09:45 PM Hi,
I have a job that execute a stored proc. It was running fine like 3
minutes to finish but a week ago it started to take 4 hours. Its using
ad hoc quries in that stored procedure. I reindex all the tables that
it was using. I check execution plan there was no tabloe scans. I
recompile the s...more >>
Need to Connect to SQL Server via TCP - Resources? Posted by Scott Townsend at 1/15/2007 7:22:15 PM I need to create my own SQL Client and am looking for resources on the
protocol used to communicate to the Server via port 1433.
Any info would be helpful...
Thank you,
Scott<-
...more >>
do you have to recreate ODBC after installing MDAC 2.8 Posted by childofthe1980s at 1/14/2007 9:59:00 AM Hello:
I just want to ask a quick question just for my future reference. There's
no emergency or anything. Take this scenario.
Client workstations have an ODBC connection, and the Terminal Services box
has an ODBC connection. The versions of the ODBC driver are different, and
you want...more >>
Transaction and locks Posted by Chakravarthy at 1/12/2007 11:24:56 AM This may be a naive question. Since DB Transactions with higher isolation
levels internally use locks, does it make sense to use Transactions for
concurrency management , in place of using some kind of pessimistic locks ?
Thanks,
Raj.
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Alter command in SP Posted by Rogers at 1/12/2007 10:06:54 AM Can I Alter any of the table through stored procedure. I tried but it didn't
work, if any one guide then I would really appreciated.
Thanks
...more >>
Problems in exporting constraints and keys Posted by Chakravarthy at 1/7/2007 9:16:24 PM When i try to replicate a production database as a new development database
by creating an empty DB called, say 'AppDev' in Enterprise Manager, and then
export the data using the Tasks->Export Data , the constraints, Primary Keys
and Foreign Keys are not exported , even though i have selected ...more >>
Linked Server Between two machines in different domains with different SQL versions Posted by alcatraz at 1/7/2007 6:16:30 AM hi everybody
well im trying to create a linked server were the source is a database
on SQL server 2000 and the destination is an SQL server 2005 and the
two servers on different domains
now when i run the openquery statment i get an error says
OLE DB provider "SQLNCLI" for linked server "...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |