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
SQL Express gives me (In Recovery) message.
Posted by Dave Dessex at 2/23/2006 11:35:02 PM
I have a fairly large database that takes up around 7GB of space on my hard
drive and on top of that, one of the tables in the datatbase with about 25
plus columns has 4 million rows. The problem I am getting is whenever I
restart the SQL Server service or at bootup, my database shows an (In ...more >>
Types of keys
Posted by clintonG at 2/23/2006 11:26:37 PM
Primary Key is usually designated as PK but what is PF as can be seen in the
Books-By-Author table in this diagram 1?
<%= Clinton Gallagher
Posted by Mark at 2/23/2006 10:16:27 PM
I have have troble with a database on our server.
I created a blank database and imported the data from the database which was
giving us problems.
I have some how linked the two databases to the one database file so when I
change one database they both change.
How can I unlink ...more >>
exporting trace output .trc files to text or excel
Posted by kunalap at 2/23/2006 9:49:27 PM
I have traces running on almost all my production servers which monitor
activities like drop, truncate and alter.
I have this implemented via server sides traces (SST). What these create are
..trc files as output.
Now manually I can open these in profiler and view them, but no...more >>
Does the /PAE /3GB switch order matter in the boot.ini?
Posted by JTT at 2/23/2006 9:07:26 PM
I have a vendor trying to tell me that the order of the switches in the
boot.ini will make a difference for allocating memory to SQL Server. We are
running Windows 2003 Enterprise Server and SQL 2000 Enterprise Server with
7GB of RAM. We have entered in the /pae /3GB switches and they change...more >>
MSDE Error 70000
Posted by Djangar S. at 2/23/2006 5:59:06 PM
Can somebody clarify what type of ther error it is ?
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Time: 3:01:03 PM
Error: 70000, Severity: 10, State: 1
Input buffer for proc...more >>
Access - restrict access issue
Posted by seal_cet at 2/23/2006 5:29:02 PM
I seems to having this issue that a database is changing itself on the
access rights to a 'restrict access for single user mode'.
Basically I did not do anything to change that mode, but may I know if there
is any way that I can prevent it changing to the single user mode? Currently
I'm ...more >>
viewing contents on networked drive
Posted by DC Gringo at 2/23/2006 4:32:10 PM
I have a backup file with many daily backups appended. I'd like to view the
contents and delete a few. The file won't fit on the local machine, so it's
on a mapped drive. When I go into EM's management, backups node, adding
this device is not allowed via this mapping--only local drives. Ho...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Send mail using sql mail and stored procedure
Posted by Jesus Suarez at 2/23/2006 3:58:31 PM
my configration of sql mail is ok.
how can i send a mail using sql mail in a stored procedure?, one example,
Constant locking issue
Posted by MC at 2/23/2006 2:47:24 PM
My SQL server has 1G Ram, and I noticed that it was using about 700MB of it
constant. Next day I looked and usage was gone up to 798 constant.
Is it possible that SQL server is not releasing the memory it is using,
thus causing slow downs, and lock finally.
My guess is that SQL server doesn't...more >>
select to diferents databases
Posted by Warren at 2/23/2006 1:50:29 PM
i need somebody`s help. I need to to make a "select" to sometables stored in
some diferent databases!
please, i need help!
nice day!...more >>
Posted by Diane Walker at 2/23/2006 1:37:35 PM
We are running SQL 2000 Enterprise Edition on Windows 2003 Standard Edition
Server. We setup a database maintenance (Database Integrity and Index,
Reorganize data and indexes, etc. ) to run every week. However, the report
shows that the maintenance job did not run because the database needs ...more >>
SQL2ksp4 sp error
Posted by mecn at 2/23/2006 1:15:20 PM
I have a sp created. everytime I run from query analyzer I got this error.
A RETURN statement with a return value cannot be used in this context.
Grouping Results (Summarizing)
Posted by vncntj NO[at]SPAM hotmail.com at 2/23/2006 12:49:19 PM
I can't figure out how to take display my results like so...
--Trenton, John Doe
--Voorhees, Jane Smith
--Philadelphia, Ken James
--Pittsburgh, Alfred Herms
--Brooklyn, Llyod Banks
--Syracuse, Howard Douglas
within a SQL statement..
Select from large heap slow
Posted by Dave at 2/23/2006 12:34:40 PM
I have a staging table that does not any indexes. I am just using the
table to store data until I DTS (transformation) it to a different
I have noticed that after a while or on large datasets the table will
become non-responsive. I can select top 10 * from the table just fine.
Loading SQL Server 2005 Enterprise Ed.
Posted by Joe K. at 2/23/2006 11:46:44 AM
I have loaded Windows 2003 Server with Service Pack1 on a new server.
What are some of the items that should be checked before loading SQL Server
2005 Enterprise Manager on this server?
Remote Connections in 2005
Posted by chris.teter NO[at]SPAM gmail.com at 2/23/2006 11:33:51 AM
This has probably been answered before, but...
I have a local SQL Server 2005 instance running, and I would like to
have another user on my network connect to this instance. However,
when he tries to connect, he always receives the same error message:
"An error has occured while establishin...more >>
SQL 2000 Trial Download?
Posted by jhardee at 2/23/2006 10:55:31 AM
How may I get a trial version of SQL 2000 on Microsoft's website? When I
search, I get a link for it
when I go to that link I get an error message. Is it simply no longer
available through them? Is there another s...more >>
Posted by Michael.Fisher at 2/23/2006 10:06:27 AM
Hi all -
We're running SQL 2000 Enterprise SP3 on Win2003 w/ 4GB of memory. Is using
AWE necessary on 2003 server? All the info I can find pertains to Win2000
Thanks -...more >>
SQL not using allocated memory
Posted by Michael.Fisher at 2/23/2006 9:48:28 AM
Hi all -
We are running an ERP application w/ SQL 2000 SP3.
By enabling 'awe', I've allocated 3GB of memory for SQL to use (verified by
exec sp_configure); however, with a reasonable load on the system, SQL is
only using 110MB. This is a quad processor box, and the CPU's have an
2 Servers - Best way to share data?
Posted by KBuser at 2/23/2006 9:43:41 AM
What we want to do is take all of our data on site, at the end of every
day, upload all of the tables which we have updated minus one table
from which we will only send all new records from the day to a server
we do not have access to. We will most likely use a delimited text
file, and FTP it to...more >>
Query Analyzer not "refreshing" Stored Procedures
Posted by ChgoBoy at 2/23/2006 9:08:12 AM
This problem first appeared last week. I'm using SQL Server 2000, and
nobody's made any modifications/updates/service pack installs recently
to either the database or the physical server. Here's the version
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Error with SQL Server 2K5 "Cannot connect... Instance failure"
Posted by ATJaguarX at 2/23/2006 8:45:07 AM
I am getting the following error when trying to connect to SQL Server
2005 Express through Microsoft SQL Server Management Studio Express
"Cannot connect to SERVER\SQLEXPRESS
Instance Failure. (System.Data)"
One thing I noticed, the "SQL Server (SQLEXPR...more >>
MSDB and PUBS Databases
Posted by Diane Walker at 2/23/2006 8:24:20 AM
We are running SQL 2000 Enterprise Edition on Windows 2003 Standard Server.
We setup a SQL backup to run under SQL. We got the messages in the report.
It said "backup cannot be performed on database 'msdb'. This subtask is
ignored." and "Backup cannot be performed on database 'pubs'. This ...more >>
Posted by George Schneider at 2/23/2006 8:00:30 AM
I need to develop a backup plan for my SQL Server using the Databse
Maintenace plan. What is the recommended configuration to backup the server.
I will be backing it up to the file system first and tehn eventual backup it
up to tape via a nother server.
Q: linked server
Posted by JIM.H. at 2/23/2006 8:00:29 AM
Is there any site that shows me steps how to add linked server in Enterprise
Moving SQL 2005 to new machine
Posted by matty2112 NO[at]SPAM hotmail.com at 2/23/2006 7:54:42 AM
I'm looking for help moving SQL Server to a new machine. The current
SQL machine runs Windows Server 2003 ... we recently upgraded SQL on
this machine from SQL 2000 to SQL 2005 (dev). The new machine runs
Windows Server 2003 (x64) and has a fesh install of SQL 2005 (dev,
I haven't see...more >>
Sql Server 2005 directories ... MSSQL.1?
Posted by matty2112 NO[at]SPAM hotmail.com at 2/23/2006 7:30:12 AM
We have one machine on which we upgraded from SQL 2000 to SQL 2005 a
couple months ago. On this machine, \Data\ is located at C:\Program
Files\Microsoft SQL Server\MSSQL\Data\. Recently we've set up a new
machine with a fresh install of SQL 2005 (x64), and on that machine,
\Data\ is located at...more >>
troubleshooting high CPU
Posted by jtdotnet NO[at]SPAM gmail.com at 2/23/2006 7:16:30 AM
Hi, first thanks to everyone for all the help in the past.
I've got a SQL std database running on a dual xeon with 2GB of memory.
I've got a process on another machine that has 4 threads calling a
stored proc that does about 5 INSERTS/UPDATES and 3 or 4 SELECTs per
My disk queue len...more >>
SQL 2005 developer edition
Posted by c_shah at 2/23/2006 7:01:53 AM
I have downloaded SQL Express 2005 and it is working fine.
I wanted to explorer new features of SQL Server 2005 SSIS (Integration
Services) on my home PC. I have SQL Express 2005 installed and
it does not have IS(integration services). My option is to buy SQL 2005
developer edition ...more >>
Posted by Pedja at 2/23/2006 6:31:40 AM
Does anybody know how to put database into standby mode (not by restoring
database...). I.E. Setting status flag to some value in sysdatabases?
sysindexes system table
Posted by Andrew at 2/23/2006 6:31:34 AM
Could someone give me a good explanation of the status column located in the
sysindexes system table.
Job with stored proc succeeds with sqlstate 01000
Posted by william_dudek NO[at]SPAM yahoo.com at 2/23/2006 6:30:49 AM
I have a stored procedure that I am executing through the sql server
job scheduler, it executes properly but after each line in the log file
there is a sqlstate message.
procedure name p_document_purge [SQLSTATE 01000]
Archiving records [SQLSTATE 01000]
51 rows archived [SQLSTATE 01000]
Import from filemaker pro to SQL Server 2005
Posted by newie at 2/23/2006 6:02:29 AM
We are trying to automate an import data from a table in a filemaker pro
database to a table in a SQL Server 2005 Database. Is this possible using
SQL Server 2005? If so, what are the steps I need to take? ...more >>
query issue with permissions
Posted by mark kurten at 2/23/2006 5:48:28 AM
i understand the difference i think between deny and revoke and how they
work but i'm confused.
if i do a
revoke select on Table1 to USER1 then run the query below (permission
query), USER1 does not show up with access
if i grant permission then use the
deny select on Table1 to USER1 then ...more >>
Measureware for SQL server 2000 - any experiences?
Posted by almurph NO[at]SPAM altavista.com at 2/23/2006 5:01:16 AM
Hope you can help me here please. We are going to stress test a VB.NET
coded application (a web service to be exact) that pulls from a SQL
server 2000 database.
I am looking for some nice free measureware that we can install easily
on the Server that will show some nice graphs ...more >>
Posted by JenC at 2/23/2006 4:16:17 AM
I have question regarding running totals, here is my SQL code so far:
SELECT Month(DateUsed) as Months,
COUNT(DateUsed) as NumUsed
GROUP BY DateUsed
What I also want in there is another column giving me the running total of
'Count(DateUsed)'. I have...more >>
SQL Server icon on the system tray
Posted by felicia112 NO[at]SPAM hotmail.com at 2/23/2006 2:54:24 AM
I don't know what i did but my sql server icon has disappeared from the
system tray and the Administrative Tool folder is blank. Can anyone
help to get it restored?
DTS Package - "Provider generated code execution exception: "EXCEPTION_ACCESS_VIOLATION"
Posted by nixonja NO[at]SPAM hotmail.com at 2/23/2006 1:51:38 AM
When running a step within my DTS package I'm receiving the following
error - "Provider generated code execution exception:
I think it may be something to do with my global variable, but I'm not
sure as I'm pretty certain I've set it all up correctly.
Below are...more >>
.NET framework compatibility with SQL Server 2000 and 2005
Posted by Abhinav at 2/23/2006 1:19:27 AM
Are SQL Server 2000 and 2005 compatible with .NET Framework? In case they
are, can I have a link or maybe a whitepaper which explains the compatiblity
between both of them.
Thanks much...more >>
Attach remote DB file
Posted by Adry at 2/23/2006 12:00:00 AM
is there a way to attach a DB's file locate on a remote path ?
why SQL Server allows attach only from local drives ?
Lock pages in memory right on IA64 edition
Posted by Tom at 2/23/2006 12:00:00 AM
I'm planing to install SQL2000 IA64 on Itanium server with win2003-IA64.
Not sure if I need to add "Lock pages in memory" right to SQL service
account or not. I know it must be used on x86 and is also recommended on x64
systems because they use AWE but on IA64 systems AWE is not used so I would...more >>