|
|
|
March 2003 April 2003 May 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 |
Filter by week: 1 2 3 4 5 HI,I am writing a table of TWO by TSQL but it gaves me error,, ANY Help? Posted by ch.adilaziz NO[at]SPAM gmail.com at 6/30/2007 2:23:23 PM declare @count int
declare @count1 int
set @count = 0
set @count1 = 2
while @count < 10
Begin
Set @Count = @count + 1
Print (@count) = (@count*@count1)
END
---------------------
Server: Msg 170, Level 15, State 1, Line 10
Line 10: Incorrect syntax near '='.
-------------
I want this t...more >>
SQL and Indexing Service on different servers Posted by Alexey Smirnov at 6/30/2007 7:12:37 AM I have a web app with a search based on Indexing Service and SQL 2000
(on the same box). Now, I need to move it to a new web server and a
separate dedicated SQL 2005. So, what should I do to be able to use
the same search using remote server?
...more >>
SQL Server 2005 and Oracle Instant Client 10.2.0.3 Posted by Joe Blow at 6/28/2007 6:58:34 PM Hello All:
Having some problems with the Oracle Instant Client 10.2.0.3 and SQL Server
2005.
WinXP Pro on a very fast PC, 3 Gig RAM, plenty of HD space.
I already got past the problem of turning on "OPENROWSET" in the "Surface
Area Configuration".
I wrote this sql statement to download a...more >>
Receive Mail Posted by mwridgway NO[at]SPAM gmail.com at 6/28/2007 4:10:29 AM Hi all.
We have a problem with our SQL2000 to SQL2005 migration where we use
xp_readmail to check mailboxes for new messages containing incoming
data. This is no longer supported in 2005. Are there any other
methods for checking mail in 2005?
...more >>
Saving in SQL 2005 Posted by Omar Abid at 6/26/2007 12:00:00 AM Hi,
Saving data in a data base table has changed from 2000 to 2005
version, why this changing and i think that 2000 is better
...more >>
Invalid value in DATETIME column.... 1 row.. Posted by AC at 6/25/2007 12:00:00 AM I had a client call today and report an error of an invalid date. I had him
backup his database and send it to me. When I got it, I looked at the table
in question and our table has 2 datetime fields in it.
Their values are:
DatePlayed: -15398-06-22 00:00:00.000
DatePosted: 2007-03-29 0...more >>
Understanding Wait_Resource ID Posted by at 6/21/2007 6:47:51 AM I need some help understanding the data retrieved from the
wait_resource column from the dynamic management view
sys.dm_exec_requests.
Normally the data returned is in the format of [database_id]:
[object_id]. Where the object_id returns the table name. That
facilitates finding your points ...more >>
Can SQL Lose Records? Posted by Neil at 6/20/2007 7:53:32 PM We are running SQL 7 with a front end that links to the tables through ODBC.
In our main table, the user has no way to delete a record through the
interface, though it is possible to delete it by opening the ODBC link.
Users would have no reason to delete a record, but one of our records turne...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Read Backup File Directly? Posted by Neil at 6/20/2007 6:24:56 PM Is there a way to read a backup file to see if it contains a file without
restoring the backup file? We are missing a record from a table, and I need
to find out when it was deleted. We have nightly backup files of the
database. Is it possible, knowing the database name, the table name, and th...more >>
How much memory can SQL Server 2000 address Posted by walterannz NO[at]SPAM gmail.com at 6/19/2007 4:36:05 PM How much memory can SQL Server 2000 std. address?
SQL Server 2000 std. is running on Windows 2003 server std edition.
Total memory was 1.5 GB but extra memory was added later.
How can I check how much memory is the SQL server configured to
address? Is there a dbcc command.
Any help will ...more >>
Server Locks and Server not responding Posted by Bill Willyerd at 6/18/2007 7:41:41 AM Hello,
I have had a couple of instances where my production server has
stopped serving. I have not been able to determine any specific
cause. On two occasions I have noticed another admin has Altered, or
installed new Stored Procs about 2 hours prior to the Denial of
Service. The db that the...more >>
When is SQL 2000 EOL? Posted by Leythos at 6/17/2007 8:23:09 PM I tried searching on MS's site and can't seem to find when they are
going to EOL SQL 2000 - anyone know?
--
Leythos
- Igitur qui desiderat pacem, praeparet bellum.
- Calling an illegal alien an "undocumented worker" is like calling a
drug dealer an "unlicensed pharmacist"
spam999free...more >>
SQL Mirroring - problem between Backup and Witness during Failover Posted by arrowtech.clayton.lee NO[at]SPAM gmail.com at 6/16/2007 7:08:58 AM I am having problems with a SQL 2005 Mirroring setup.
Here is the configuration:
4000A - IIS NLB/SQL 2005 Witness
4000B - IIS NLB/SQL 2005 Backup
4000C - SLQ 2005 Primary
All three servers have 3 nics - 1 internet facing (and for A & B
configured for NLB), 1 for backend communication and...more >>
How to retrieve results from a dynamic SQL query Posted by InvestorTrade at 6/15/2007 1:41:58 PM Hi,
I have a query that is formed dynamically, and I need to be able
store the result in a variable, and example of this would be:
BEGIN
DECLARE @myresult int
DECLARE @query = 'select count(*) from sysobjects'
SET @myresult = exec (@query)
END
I thought of using Glo...more >>
Transaction logs Posted by Andy at 6/14/2007 5:26:31 AM Hi,
I have a database, recovery model full.
I have a maintenance plan that does a full backup everyday at 6:00
PM. I also have another plan that does only transaction log backups
every hour during business hours.
My question is, when is it safe to delete the old logs? Never? After
the...more >>
Year to Month Calculation Posted by Dip at 6/14/2007 1:01:17 AM Hello Expert,
My data table looks like below:
DIV Year MonthCode Month Actual Vendor
AA 2001 3 SEP-00 200
BANTHORP PTY LTD
AA 2001 4 OCT-00 100
DELTA SALES PTY LTD
BB 2001 5 ...more >>
SQLLitespeed x64 intermittent failures Posted by brent.mccracken NO[at]SPAM gmail.com at 6/13/2007 10:09:25 PM I've run out of options so I'm putting it out to the community for a
solution. The error message is;
BackupMedium::ReportIoError: write failure on backup device
'VDI_0AF26571-DF14-4572-88BE-4E2097AA25C5_0'. Operating system error
64(The specified network name is no longer available.).
We're...more >>
Major Problem - lost my whole database Posted by iporter at 6/12/2007 9:24:06 AM Hi, I need some help.
I've been trying to detach my SQL Server 2005 Express database so as
to attach it to my remote server. This has worked in the past, but I
can't get it to work this time - it attaches to the remote server as
read-only. However, then suddenly it would no longer attach bac...more >>
Time Posted by Paul at 6/12/2007 12:00:00 AM Is it possible to set the server clock using SQL. I have full admin rights
to the SQL server, but not to the windows 2000 OS.
Problem I have is that the clock is 6 mins fast, and I am struggling to find
an administrator each time the clock "slips"
...more >>
SQL Server 2005 with VB.net 2005 Posted by Omar Abid at 6/9/2007 12:00:00 AM Hi every body,
Im using VB 2005 to create a program that open SQL Data base
The problem that i want to detect the tables of a database
so how can i know a data base tables instantly
Thank you
omar.abid@hotmail.com
omar.abid2006@gmail.com
Omar abid
...more >>
sql questions Posted by veeru at 6/8/2007 11:48:18 PM hi,
these are some question i faced in a test, please post ur
answers .
1.The IF UPDATE(column_name) parameter in a trigger defination will
return
TRUE in case of an INSERT statement being executed on the triggered
table
--is this statement true/false.
2. Which of following datatype...more >>
difference in adding domain user logons? Posted by Leythos at 6/8/2007 7:24:34 PM When I select a set of logons, my picking domain users, it adds then as
username (their user name), but when I add them one at time they get
added as domainname/username.
What is the difference?
--
Leythos
- Igitur qui desiderat pacem, praeparet bellum.
- Calling an illegal alien an ...more >>
SQL Job question Posted by Doug at 6/8/2007 12:00:00 AM Newbie question.
I have 6 tables that need to have records deleted from them nightly based on
date. I can create 6 SQL jobs for this to run every night, but rather than
create 6 separate jobs, can I put 6 DELETE statements into one SQL job? For
example...
DELETE
FROM table1
WHERE datea...more >>
tablename alias Posted by Jeff Kish at 6/6/2007 12:56:04 PM Hi.
is it possible (I'm getting errors) to do this?
delete from table h where h.col 1 = h.col2
right now sql server 2005 seems to barf on the 'h', but oracle (and db2) does
not.
I supposed it might be a compatibility setting, but I wanted to check.
I see in the t-sql online reference tha...more >>
mirroring Posted by luna at 6/6/2007 12:00:00 AM i've been asked to look into an off site machine as part of some risk
management.
plan is to bring the machine in on a weekly basis for updating, as opposed
to constant mirroring,
i was thinking of using mirroring, then using pause/resume, would this be a
good idea ? or is there a better...more >>
What can I do with garbage records in sys.database_files and sys.master_files? Posted by gapokrif NO[at]SPAM gmail.com at 6/5/2007 6:31:27 AM I have MS SQL server 2005 + SP2.
After some manipulations with database I have orphan records in
sys.database_files and sys.master_files views . They related to full-
text catalog but actual catalogs don't exist. It happened because I
replaced database files with backup copies when sql server wa...more >>
Restore Database Fails Posted by Neil at 6/4/2007 3:50:42 PM I'm trying to use ADO to restore a SQL 7 database using a backup file. The
database already exists on the target computer, and is named the same as on
the source computer, and the MDF and LDF files are named the same as well.
I am running the below in a stored procedure:
RESTORE DATABASE DB1...more >>
best way to design for storing application variables Posted by ricva at 6/1/2007 5:23:09 AM We have an application which has its settings stored in a database
(SQL Server 2000)
We have (strong) disagrements on the best way to store these values,
and I am looking for advice on doing this.
Most of the values are not used by the stored procedures, just the
applications running on the c...more >>
dbinit(), dblogin(), how often? Posted by Bruce. at 6/1/2007 1:11:48 AM I'm a MS SQL newbie and am programming SQL using MS DS C++ 2003.
I'm writing sql code that will reside in a shared dll, used by many
processes and many threads in those processes.
So how often do I need to call dbinit()? Only the first time the DLL is
loaded, once per new process, once pe...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |