| 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 |
LOG files Posted by Raul Rego at 6/30/2006 12:00:00 AM I have an SQL database in MSSQL 2005 that holds 200MB and the log file is
holding 57GB.
can I delete the log file? do I need it? Can I compress it?
thanks,
Raul Rego
...more >>
Saving a quey causes the task to hang Posted by Peter from holland at 6/29/2006 6:02:03 AM Hello,
One of our PC's (Windows 2000 prof.) has some times problems saving a query.
Sometime (after queries are changed and) we try to save the query with
another name (save as), the saving action works but the query window is
hanging (stops responding). The SQL-analyser has to be restarted
...more >>
Scheduling of snapshot agent Posted by perhiyar at 6/27/2006 11:17:26 PM I have replicated a database as a snapshot replication. I have
scheduled distribution agent to run at the interval of one hour daily
from 9:00 AM to 5:30 PM. Do i also need to schedule snapshot agent
accordingly? What will be optimal schedule depending on the scheduling
of distribution agent?
...more >>
failed because the SET options have incorrect setting 'ARITHABORT' Posted by Jassim Rahma at 6/27/2006 6:33:02 AM Why i am getting this error:
update failed because the following SET options have incorrect setting:
'ARITHABORT'
when i try the following simple SQL in the SQL Management Express 2005:
update rates set rates.ORIGIN = '800880011_ali' where rates.rate_plan_id = 3...more >>
Fill empty fields in a table with the results from another field. Posted by Steff at 6/23/2006 8:42:55 AM Hi guys, your assistance would be appreciated.
I have two columns in my customer table; customer number and stats
customer number.
Customer number is mandatory and unique, stats customer is neither nor
and is used to group customers together when, for transactional
reasons, it is necessary t...more >>
Images in SQL Posted by I notice that SQL 2000 has a datatype of image.
My question is after I setup the table and fields how do I populate the
table with image data?
...more >>
how to convert KB to MB Posted by Ricky at 6/21/2006 8:12:05 PM Hi
I need some help in how to convert a certain value in KB into MB. Please see
the bellow script where i put the question.
Thanks
[]
Ricky
select location+space(1)+'-'+space(1)+dept as 'Location',
compname as 'Computer Name',
ext_mem as 'Memory',
computermodel as 'Model',
drive_c as...more >>
Problem with SQL Job Posted by sandy at 6/21/2006 6:10:05 AM Hi,
I have a table DataCleansingJob_History which consists of the columns
ID, StartTimeOfJob,
EndTimeOfJob, NoOfDays.
I have a Stored procedure that has an input argument @NoOfDays
I have a Job ScheduleDataCleansing which calls the above stored
procedure in its command as
follows:
EXEC...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQL at client site Posted by Yousuf Khan at 6/20/2006 9:30:03 PM i want to deploy a project at client i have developed a project in vb and sql
that i want ot deploy at client my right now i dont to install sql database
at client site, with out intalling sql how can i acces table and all in my
project do i need to copy any files and is ther any other way ple...more >>
T-SQL Grammar file Posted by Diego L Espiñeira at 6/19/2006 6:09:08 PM Hi!
Anyone knows where could I find the Transact-SQL grammar in BNF form?
It whould be very usefull to me, in fact it would save my job!!
I'm currently migrating code between different DB engines. I really need
help!!
Pleasee!!!
...more >>
sp_changeobjectowner 550 tables. Posted by Rogers at 6/19/2006 11:05:48 AM I want to change the owner of 550 tables in single command, is it possible ?
Thanks
...more >>
Track the IP Posted by Rogers at 6/19/2006 10:54:40 AM Is there anyway, I can see in SQL Server who is logged in to the production
box through which IP address?
Thanks
...more >>
SQL 2k5 client requirements Posted by Ata John at 6/19/2006 6:22:02 AM Hi all,
Does anybody know what are the system requirements to install the 2005
client at a workstation?
Do we need Framework or just MDAC 2.8 sp1 and XP sp2?
Thanks...more >>
Reference an alias field name in an SQL Statement Posted by Kent Prokopy at 6/16/2006 11:23:25 AM Is there a way to Reference an alias field name in an SQL Statement?
Example:
Select
1 + 1 AS F1,
F1 + 1 AS F2
...more >>
SQL2005 Client Tool: very slow to start ? Posted by SoftLion at 6/15/2006 3:51:26 PM Hi,
I'm wondering why Management Studio is so slow to start.
It seems blocked during 30s to 1mn. Is it scanning the network for database
instances ? What is he doing ?
Is it possible to connect to a SQL2005 non default instance with the SQL2000
mmc client tool ?
Is there a SQL2005 mmc clie...more >>
how i can make script Database with Data? Posted by Tark Siala at 6/14/2006 3:57:40 PM hi
i am working on Windows 2000 Advanced Server + SP4 and SQL2000 Enterprise +
SP4.
i have database contains Tables, and i want make script to build Tables on
other Database,
but i need this script include Data in Tables too, i can make that ? and
how?
thanks
--
Tarek M. Siala
...more >>
Newbie ques - client workstation computers Posted by Sandy at 6/14/2006 11:29:01 AM Hello -
Dumb question -- I have installed Sql Server 2000 on a server (W2k). There
is an application that accesses a database on the server.
What do I need to do to the workstation computers to enable them to access
the database? They are running Windows 2000.
--
Sandy...more >>
single user(database name) Posted by ae at 6/13/2006 9:57:02 PM i couldn't log on to sql server from the client. i then looked at the
database and there was a single user description next to the database name
label. I then closed the server and opened it back up, and the description
disappeared and was then able to login as though nothing had happened. w...more >>
Group Query Question Posted by PolarBears at 6/12/2006 10:49:01 AM How do you pull all fields of a record when grouping? For example, say I
have a database of fish caught and I want to group by Lake and take the
largest fish from each lake. It is easy enough to say "Group By Lake" and
then in the Select List Select "Max(Weight)" to get that field, but when ...more >>
URGENT! Client problem Posted by Denis Zoddi at 6/9/2006 12:00:00 AM I've installed the enterprise client manager for SQLServer 2000 but when I
launch it I get an error regarding snap-in in the right panel
I've tryed
regsvr32 C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlmmc.dll
Gave me an error
DllRegisterServer in sqlmmc.dll failed.
Return code w...more >>
SQL Server 2005 Express Edition :: Connection Limit Posted by Muhittin Kara at 6/8/2006 2:58:04 PM MSDE has a connection limit (as far as i remember, you can't open more than
20 connections at the same time) but other editions of SQL 2000 has no limit
for opening connections. Is there a limit for how many connections can be
opened to SQL 2005 Express edition at the same time.
...more >>
SQL2005 Client Software Posted by Chris Wood at 6/7/2006 8:11:51 AM Hi,
I asked this question on the main server NG and have seen no replies. Maybe
someone will answer here?
Hi,
In SQL2000 we would only install the Client Tools on a workstation. With
SSIS as a new standalone service should we be installing SSIS on Client
workstations as well as the Clie...more >>
sql server 7 - sql server 2000 Posted by Rogers at 6/6/2006 1:11:32 PM Can any one give me the step by step documentation how we can upgrate SQL
Server 7 - SQL Server 2000 database that include all the maintainance plan
and all the jobs and every thing.. Or any website through which I can go
step by step ...
Thanks
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |