all groups > sqlserver server > august 2006 > threads for monday august 14
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
SQL 2005 - Old Clients working?
Posted by christian at 8/14/2006 11:42:39 PM
Hi everyone,
i am just about to upgrade from SQL 2000 to 2005. I am just wondering
if the old SQL 2000 clients (ODBC, OLEDB) work with 2005 or do i have
to upgrade the client beforehand?
What about the Query Analyser from 2000? Does it work with 2005 as
well?
Thx for your help,
Christ... more >>
Restore 2005 DB to SQL server 2000
Posted by Denis Laskov at 8/14/2006 10:49:01 PM
Hi all
there is a lot of questions and answers about how to transfer DB 2000 to SQL
server 2005. But is there way (I hope) that allow to transfer DB between SQL
server 2000 and 2005 vise versa?
I'd connetced between SQL server 2000 and 2005 and exported DB from 2005 to
DB in 2000. But from 3... more >>
XML SQL Server 2000
Posted by kwangsa at 8/14/2006 9:50:58 PM
Hi, Do anyone know how to hold xml text into variable ?? The scenarion
that i am facing right now is i have a TEXT column in Table A which
store the xml file, and in another sproc in need to retrieve that XML
TEXT COLUMN and read it. But the problem that i am facing is that SQL
Server 2000 not ... more >>
Using sp_who or sp_who2
Posted by cbrichards via SQLMonster.com at 8/14/2006 9:17:23 PM
When using sp_who or sp_who2, or even variations of it in script libraries on
the web, it seems like the spid number in the blkBy column is always the same
as the SPID in the SPID column. How is that any help? It seems like the BlkBy
value (SPID) should show a different SPID value, as in, the SPI... more >>
Can this be done with sql?
Posted by Ranginald at 8/14/2006 7:53:27 PM
I am trying to produce a query that will create a sorted list and I
don't know if it's even possible.
Here's what I aim to have the query return:
Category1
item1 description
item2 description
Category 2
item1 description
item2 description
Here are the two tables.... more >>
Create table problem
Posted by Farrukh at 8/14/2006 7:00:40 PM
I have been trying to create a table since morning but it save as a system
table instead of a user table. anybody has any idea? I tried to create both
GUI(Enterprise) and Analyser prompt but all the the time system made a
system table instead of a user
thanks
... more >>
Sporatic Slowness with SQL 2k
Posted by hroyale at 8/14/2006 6:02:43 PM
Hi.
We have a SQL Server 2000 db running an on-line app. It has been pretty
solid for several years. Our original DBA moved on about 6 months ago
and we're hitting our first busy season since he left.
Now we're experiencing some very strange DB slowness. The CPU and memor
on the box look good... more >>
Problem With RecordSet
Posted by J Bowman [293288] at 8/14/2006 6:00:15 PM
Hello SQL ASP guys,
I have written this small code:
<% @ Language=VBScript %>
<html>
<head>
<title>SQL Test</title>
</head>
<%
Dim objConn
Dim objRS
Dim strSQL
Set objConn = Server.CreateObject("ADODB.Connection")
Set objRS = Server.CreateObject("ADODB.Recordset")
objConn.Open "Pr... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Affect of FillFactor on Index
Posted by cbrichards via SQLMonster.com at 8/14/2006 5:01:08 PM
I am trying to understand how the fillfactor might be affecting the clusered
index.
The primary key (nonclustered) on the table is a composite index of two (int
data type) fields, where one field is an identity seed incrementing by one,
and the other field being more constant.
The non-uniqu... more >>
LCK_M_U
Posted by Olivier Matrot at 8/14/2006 4:12:25 PM
Hello,
I'm in the process of stress testing my database design.
Basically, I have a table that store user data. The table is accessed by
many users at the same time, but the same range of rows are not accessed
simultaneously (each user access it's own data).
During stress testing, I'm looki... more >>
Install problems on one system
Posted by David Thielen at 8/14/2006 4:09:01 PM
Hi;
I have VMWare on a test computer and installed the dev version of SqlServer
2005 fine on the frist VM partition.
However, on the second it won't let me check the reporting services and
requires a strong password. Why???
--
thanks - dave
david_at_windward_dot_net
http://www.windw... more >>
Auto shrink not working as expected
Posted by Paul Bergson at 8/14/2006 3:53:52 PM
I'll be the first to admin, I am not a sql expert. I have a nightly job
that backs up the tran logs on my db's and the box is checked to autoshrink
the tran log when it exceeds 100 mb. There are no errors and the shrink is
executed as shown in the log reports but the size doesn't appear to c... more >>
ASP Pages on Windows Longhorn
Posted by J Bowman [293288] at 8/14/2006 3:26:16 PM
Hello Guys,
I have .asp installed on longhorn server and everytime I goto look at the
page, I get a 500 internal server error..
Anyone got any suggestions!
Thanks
J Bowman
jbowman@neo.rr.com
... more >>
Move DB from Sql Server 2000 to Sql Server 2005
Posted by David Thielen at 8/14/2006 3:18:02 PM
Hi;
How can I move a database from Sql Server 2000 to Sql Server 2005 (different
machines, same domain)?
--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htm
... more >>
Where is Northwind?
Posted by David Thielen at 8/14/2006 3:17:02 PM
Hi;
I just installed the dev version of Sql Server 2005 and I can't find
Northwind. Is there a way to get it?
--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htm
... more >>
Restoring 2000K DB on a 2005 Box
Posted by shub at 8/14/2006 1:50:06 PM
After I restore a 2000K DB on my 2005 box everthing appers to be fine
until I try to delete the associated users from the restored db. When I
attempt to delete the users I get an error the only way I can get
around it is by deleting the schemas first before I delete the users.
Is that the only w... more >>
SQL 6.5 backup
Posted by Mark at 8/14/2006 1:39:02 PM
I've got a SQL 6.5 backup that I'm trying to restore, because the original
media was damaged. When I restore it, after about half an hour, I get an
"unexpected end of dump" error.
Here's my question: should the backup file be approximately the same size
as the database? sp_helpdb on the ... more >>
Urgent need of restoration assistance
Posted by Rus at 8/14/2006 1:38:02 PM
Inadvertently issued an update against an entire table instead of a single
row. Anyone have any ideas on a method for rolling back that transaction
from the log - to keep me from having to restore of the .bak?
... more >>
inner join on varchar(50)
Posted by JIM.H. at 8/14/2006 1:19:01 PM
Hello,
I am doing inner join on varchar(50) fields, although I am sure the same
data is available on both T1 and T2 but I am not getting anything with this
inner join.
SELECT *
FROM T1 INNER JOIN T2 ON T1.FirstLastName = T2.FirstLastName
What might the problem be?
... more >>
The Sql Server 2005's 8000 Byte Encryption Limitation and Large Binary Files
Posted by CodeNow at 8/14/2006 1:01:48 PM
I am using SQL Server 2005's encryption functionality (i.e.
encryptByCert/Key/AsyKey/PassPhrase) to encrypt my data on the SQL
Server.
The max size these encryption functions return is a varbinary of 8,000
bytes. So if you attempt to encrypt a 100 Mig binary file, the data
would have to be ch... more >>
SQL 2005 Performance versus SQL 2000
Posted by Bru at 8/14/2006 12:01:02 PM
We have a legacy application written in C++ that uses ADO to access a SQL
Server 2000 database. When we change to using SQL Server 2005, the
performance drops around 40% (Example runs went from 3 min to 5 min etc,
consistent for larger runs as well). We created a small test application that
... more >>
Find number of records in text file.
Posted by ntuyen01 NO[at]SPAM yahoo.com at 8/14/2006 11:54:56 AM
Hi All,
Is there a way to find out how many records (rows) in the text file in
sql. ( It is a fix lengh record)
Example: I have a text file in my local machine
c:\test\t1.txt
c:\test\t2.txt
in t1.txt I have these rows:
AAAAAAAAAAAAAAAAAAAAAAAAAAA
BBBBBBBBBBBBBBBBBBBBBBBBBBB
CCCCCCCC... more >>
dynamic sql
Posted by scott at 8/14/2006 11:11:02 AM
the following dynamic sql statement will not run in a stored procedure when I
run the stored procedure see error below, does anyone know why?
Create Procedure StandEdit_ErrorCheck
@TableName VarChar(100)
AS
Declare @SQL VarChar(1000)
--Check for Duplicate Standids
SELECT @SQL = 'SELEC... more >>
Finding date using PATINDEX in varchar
Posted by sfazili NO[at]SPAM gmail.com at 8/14/2006 9:56:34 AM
Hi:
One of the columns in my table is a notes column i.e everytime a user
updates it the date,time, users name and his/her note gets appended in
front. The notes column has text in following format:
8/4/2006-9:46:37 AM-Linda King-Per MDCR no clm on file,reblld.
5/4/2006-9:19:09 AM-Jenny Hop... more >>
sql 2005 x64 "best practices"
Posted by bill at 8/14/2006 9:21:02 AM
I recall reading in BOL that for x64 systems (sql 2005 x64 and the OS x64
versions) that there was a recommended sql config tweak that to optimize
performance or memory usage. Anyone recall what this could have been? (I
can't locate it now, but I recall reading it.)
TIA,
Bill
... more >>
sql 2005: Enabling page level locking....
Posted by bill at 8/14/2006 8:34:02 AM
The database referred to is a sql 2005 DB using Simple recovery mode. It is
backed up daily using a job created by the SSMS Maintenance Wizard. Anyone
know how to "enable page lockng"? (The DB DBCC's just fine.)
Bill
Executing the query "ALTER INDEX [idx_ItemNum] ON [dbo].[ItemNum]
REO... more >>
SQL Server trigger that fires only on update of certain field?
Posted by dba_222 NO[at]SPAM yahoo.com at 8/14/2006 7:01:48 AM
Dear Experts,
I'm an Oracle guy, who is being given more SQL Server assignments
lately.
I've been looking for things on the web about this, but I can't
anything so far.
In Oracle, I you can create a trigger on a table that -only- fires if
certain fields are updated.
create or replac... more >>
Interesting Query Problem!
Posted by simon.stockton NO[at]SPAM baesystems.com at 8/14/2006 5:15:45 AM
Dear All,
I have three tables:
teams table
id name
----------------------------
1 Team A
2 Team B
3 Team C
4 Team D
fixtures table
id home team id away team id
-----------------------------------------------... more >>
Query execution time using an ORMapper
Posted by RobRoma at 8/14/2006 3:48:01 AM
Hello there!
I have a strange problem regarding the query execution time of a
parameterised query executed over sp_executesql. We use an ORMapper
(NHibernate) which generates the query, so it is not necessary to discuss the
use of sp_executesql. If I run the query in SQL Server Management S... more >>
Adding page numbers by using the template "Report Model Project"
Posted by René at 8/14/2006 2:41:59 AM
Hi,
I'm trying - without results - to introduce pagenumbers in my reports
which are made by using the template "Report Model Project" of Visual
Studio 2005. I'm using SQL Server 2005 Reporting Services. Does anybody
know if this is possible en if so how to do it?=20
Ren=E9
... more >>
SQL Database - Still In Use?
Posted by Darren King at 8/14/2006 12:00:00 AM
Dear All,
We are currently in the process of migrating databases from a SQL server
which is out of warranty and due for decommissioning to a new SQL server -
both servers are running SQL Server 2000.
We suspect a large number of the databases are old and no longer in use, is
there a way ... more >>
Comparing the schemas of two databases
Posted by Mark Rae at 8/14/2006 12:00:00 AM
Hi,
In SQL Server 2005, is there anything built-in which will compare two
databases and show how their schemas differ? Something similar to the Red
Gate software?
Any assistance gratefully received.
Mark
... more >>
SQL Express User Connection Limitation on Windows XP Pro
Posted by Henry at 8/14/2006 12:00:00 AM
Hi,
Is there any limitation on user connection (no. of user) if SQL Express
running on Windows XP Pro?
Thanks,
Henry
... more >> |
