| Groups | Blog | Home |
|
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 |
Filter by week: 1 2 3 4 5 16 Bit SQL Client Problem. Posted by Incognito at 4/21/2005 1:40:05 PM I am in a real bind - I need to locate and install the 16 bit SQL client on a
system and I cannot find my copy of SQL v6.5.
I have SQL 7 & 2000, but both of these packages don't seem to offer 16 bit
connectivity.
Does Microsoft offer any 16-Bit SQL client downloads? Any help would be
g...more >>
Identity Posted by Joh at 4/21/2005 12:26:52 PM The @@identity return the last inserted value in the database and the
scope_identity return the last inserted value with that scope right ?
...more >>
How to list atributes of all tables in Query Analyzer Posted by Gabriel Martin at 4/21/2005 10:34:02 AM Hi newsgroup
I need to know the properties of all tables in a given database on MSSQL
7.0. I know that there is a stored procedure with the name "sp_MShelpcolumns"
as well as another one called "sp_MSforeachtable". How can I combine these
two to get a result that looks like: tablename, colu...more >>
SCHEMABINDING Posted by Joh at 4/20/2005 3:03:19 PM WHAT ARE THE BENEFITS OF SCHEMA BINDING WHILE CREATING THE VIEW.
...more >>
Views Posted by Joh at 4/20/2005 10:21:46 AM Can anyone help me regarding the optimization of the following view because
the dbo.vw_Main view calls vw_St_Un view and vw_St_Un view calls vw_S_OnS
and vw_S_Tfer view... when I execute the Main view it take long time... can
one give me his / her expert idea.
thanks in advance.
___________...more >>
Major difference. Posted by Joh at 4/19/2005 3:08:55 PM What are the major difference b/w rebuilding indexes and update statistics
thanks
...more >>
Rebuild all the indexes ? Posted by Joh at 4/19/2005 2:53:19 PM Can anyone let me know like we need to rebuild all the indexes of all tables
every day? or the specific indexes?
Thanks
...more >>
default database directory Posted by Joh at 4/19/2005 2:46:47 PM Is it possible like when I create the database so it creates the database in
C:\Data folder and log file at D:\log folder by default. I think we can do
some thing in model database, if yes then can any one let me know how can I
do this ?
thanks
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
REBUILD Posted by Joh at 4/19/2005 2:34:28 PM What is the recommandation like how frequently we need to rebuild the
indexes, every day ?
Thanks
...more >>
Convert into Default Instance. Posted by Joh at 4/19/2005 1:56:23 PM I have by mistaken installed Named Instance, now I wanna convert this as a
default instance, how can I?
Thanks
...more >>
Maint. Plan Posted by Joh at 4/19/2005 12:52:29 PM There is a Database Maintaince plan exist in my database but I want to check
what this database maintaince plan do? Can I know through any command or
query ?
...more >>
recommendation Posted by Joh at 4/19/2005 9:48:43 AM Can anyone let me know what are the best recommendation for optimizing SQL
Server and database.
Thanks
...more >>
Odbcping Posted by דובקה at 4/19/2005 2:37:02 AM Hye,
I have client tools only, install on my computers. and I wolud like to use
odbcping from my machin. does it possible to install the odbcping, because
right now i dont have it install on my computer.
Regards,
Dubka....more >>
ShowContig Posted by Joh at 4/18/2005 9:25:07 AM Can any one explain me regarding the following (Scan Density [Best
Count:Actual Count] should be 100% right? ) I used DBReindex command but
it's not growing till 90% - 1000%, what I have to do?
DBCC SHOWCONTIG scanning 'Medical' table...
Table: 'Medical' (1388284451); index ID: 1, database ID:...more >>
SQL Syntax errors Posted by Greg Higginbottom at 4/18/2005 5:18:00 AM Migrating some code from a true SQL Server to MSDE. Keep
having 'syntax problems near keyword error???'
Any clues. Runs fine on old server....more >>
T-SQL table variable Posted by Marco at 4/18/2005 12:00:00 AM Hi friends,
First of all sorry for my english.
I have SQL 2000 server Sp3 on my network, i want know if is possible use a
T-SQL table variable with adodb technology.
The stantment that I want to execute is like this one:
Dim conn : Set conn = Sever.CreateObject("ADODB.Connection")
conn.C...more >>
is null in where clause does not work properly Posted by Terence Leung at 4/15/2005 2:23:01 PM We have a very simple select statement:
select E.COURSE_YEAR, E.COURSE_SESSION, E.COURSE_CODE, E.FLAG
FROM enrollment e
where
e.course_year=2005
and e.course_session=2
AND E.FLAG IS NULL
There were 16743 records returned but more than half of them contain a value
in the FLAG field....more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |