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
Maximum memory that SQL 2005 standard can use....
Posted by Mousehunt at 2/13/2006 10:38:27 PM
We intend to get a new Windows 2003 standard server with 8GB Ram. We will
also be installing SQL 2005 standard on the same system.
We are aware that Windows 2003 standard server supports up to 4GB Ram and
SQL 2005 standard support up to the maximum ram the server has.
Our question i...more >>
Transfer table objects SQL2K > SQL2005
Posted by clintonG at 2/13/2006 10:13:14 PM
I need to learn how to transfer some table objects from a local instance of
an SQL2K server to a local instance of an SQL2005 server. Is this possible?
<%= Clinton Gallagher
An attempt to attach an auto-named database failed
Posted by Noah at 2/13/2006 10:09:26 PM
I have a problem with Microsoft SQL Server 2005 Express,
My web application runs fine on my development PC, but when I copy it to my
server (My server is running Windows 2000 Server) and try to access it from
the web I get following error:
An attempt to attach an auto-named database for file...more >>
Posted by donsql22222 at 2/13/2006 4:38:26 PM
Looking for suggestions about what I might look for..
During periods of time when no INSERTS are taking place, SELECT statement
durations are around 16-30ms for hundreds of requests per minute.
When there is a batch of INSERTS that are sent to the table via SP that
number in the many thous...more >>
SQL Server 2005 licenses for development purpose...
Posted by Jéjé at 2/13/2006 4:37:13 PM
what is the licensing model for a development purpose?
I have 1 dev server and 10 developpers with all the admin & dev console
Which version of SQL Server is required?
Can I install SQL Server dev on my server and give access to all my
I don't see any price...more >>
Update 2000 Rows with Different Data
Posted by Damon Johnson at 2/13/2006 4:02:29 PM
I just noticed there are two of the server listings ( original list and
revised). Please forgive for reposting, not sure if 1st post will post here
I have sql2k EE. I have a table named INVENTORY. It has two colums
3 ...more >>
Update 2000 Rows with Different Data
Posted by Damon Johnson at 2/13/2006 3:58:27 PM
I have sql2k EE. I have a table named INVENTORY. It has two colums
Currently there are 2000 partnumbers in this table. All the partnumbers have
0 in the cost field. I want to update each part nu...more >>
Posted by Sanjay at 2/13/2006 3:53:27 PM
is there a function which does cumulative in SQL Server 2000
Don't see what you're looking for? Search DevelopmentNow.com.
Indexing issue, inconsistent performance
Posted by Steph at 2/13/2006 3:18:25 PM
Trying to chase down a baffling performance issue. Our database has been
running very slow lately. So we are performance tuning the database. In
doing so, we created a copy of our production database. In that database, I
changed one clustered index on a table to try to improve performance...more >>
SQL 2005, ODBC link table, and replication
Posted by TCorp at 2/13/2006 3:17:34 PM
I am experiencing some strange behaviour when I try to insert rows into my
SQL Server 2005 DB through ODBC.
I use MS-ACCESS ODBC linked tables to insert rows into my SQL Server 2005
db. When I insert a row into a linked table (by typing data into it) the
row "disappears" and is replaced by...more >>
Where are stored procedures in SQL Server 2005 Express
Posted by simon NO[at]SPAM intology.com.au at 2/13/2006 3:17:11 PM
Trying SQL Server Management Studio Express I'm missing any view or
access to stored procedures. Any ideas why they don't show?
Cannot start SQL Server 2005 service
Posted by batgirl at 2/13/2006 2:01:24 PM
I have a SQL Server 2005 instance installed. I have created databases and
schema on the SQL Server. I cannot start the service for the SQL Server. I
ahve tried using every account possible. It always errors out with the
initerrlog: Could not open error log file 'C:\Progr...more >>
SQL 2005 Permissions For User
Posted by scorpion53061 at 2/13/2006 1:56:13 PM
Looking for what permissions to set for user to allow them to
change/write/modify/edit only those databases.
add logins for only their databases
Thanks for any help.
SQL Server logs
Posted by gbarendt at 2/13/2006 1:47:49 PM
I am looking to set up automated scraping of SQL Server logs to notify
me of serious problems with the server. Is there a list anywhere of
common/serious/all messages that SQL Server might log to the Event View
or its own log files?
Cannot use backup file %s. Originally formatted sector size 512 and now device sector size 2048.
Posted by Ian Boyd at 2/13/2006 1:39:38 PM
Customer is trying to restore a backup of their database. SQL Server gives
Cannot use backup file %s.
Originally formatted sector size 512 and now device sector size 2048.
Only one guy (in Germany in March 2000) has ever seen this error. And he
never got a resolution.
Changing name of SQL Server
Posted by Sean Donnelly at 2/13/2006 12:40:50 PM
I need to change the server name of my SQL Server to one of a current SQl
server that is being decomissioned since the newer server is faster, more
disk space, etc. Do I need to do anything with the named instances on the
server I am renaming, as i want to make sure that System DSN's and such ...more >>
data "movement" the culprit?
Posted by ChrisR at 2/13/2006 12:40:07 PM
I have a report query that sometimes runs in 3 seconds, other times I kill
it after 10 minutes. When its taking a long time, there is no no blocking, no
extremely high cpu/ memory usage, no huge amount of activity. Something I
just noticed though is that someone put the Clustered ...more >>
Database Size Bloating after SP4.
Posted by Sam Davis at 2/13/2006 12:38:47 PM
Has anyone had any issues with a database doubling or tripling in size after
SP4 is installed? We have several databases that are structurely the same
however certain DB's have grown enormously in size without a large increase
in data. Whenever we try to shrink the Database it won't shrink to ...more >>
Horrible Bad Performance on Gargantuan Hardware
Posted by SSGTech Tim at 2/13/2006 12:36:55 PM
I was asked to look at server running Windows 2003 Standard (Version
5.2(Build 3790.srv03_sp1_rtm.050324-1447: Service Pack 1), Quad Xeon
processors, running 4Gig of RAM with a 33Gig OS drive and a 1.5 Terrabyte
Data array partitioned into a 1 terrabyte partition and another .5 terraybt...more >>
extended stored procedure sp_sdidebug is missing
Posted by Jack at 2/13/2006 11:36:42 AM
I like to debug stored procedures, but the sp_sdidebug extended stored
procedure is missing on my server (master database). How can I recreate
Sp_createstats 'fullscan' in 2005
Posted by shub at 2/13/2006 11:31:20 AM
When I run the command below on SQL Server 2005 box I get the
exec sp_CreateStats 'fullscan'
Msg 15600, Level 15, State 1, Procedure sp_createstats, Line 27
An invalid parameter or option was specified for procedure
The same command seems to run fin...more >>
Memory Usage from sql server.
Posted by MariaGuzman at 2/13/2006 10:57:31 AM
Hi, I have a server that has sql server2000 sp3 on win2000 server sp4.
On this server every day runs a process that take about 3 minutes to
finish. But once a month it takes about 30 min. or one hour to finish.
At this moment the only thing that help us to fix the problem is to
restart the serve...more >>
syspermissions value for statement permission -- repost for no response
Posted by Quentin Ran at 2/13/2006 10:37:19 AM
in the table syspermissions, the column actadd and actmod holds the
statement permissions when id = 0. The columns contain combined bitmapped
values for various statements (or object permissions when id > 0). But what
is the value 256 for? I found the other ones but only not th...more >>
SQL Server Randomly Not Responding
Posted by davidkrainess NO[at]SPAM yahoo.com at 2/13/2006 10:19:09 AM
I have the following environment:
SQL Server 2000 SP4 (4 Processor, 8 Gb Ram)
Windows 2000 Advance SP4 with PAE
10 Gigabyte Database
300 Computers Connected using MS JDBC Driver
Server had been running for 8 months with no problems
Database is purged weekly
Log backup Sql2k
Posted by mecn at 2/13/2006 10:17:54 AM
I got this error for log backup.
'Test_log_Backup' is incorrectly formatted. Backups cannot be appended, but
existing backup sets may still be usable. [SQLSTATE 42000] (Error 3266)
BACKUP LOG is terminating abnormally. [SQLSTATE 42000] (Error 3013). The
Posted by David A. Beck at 2/13/2006 9:38:02 AM
When I switched to a multiple processor SQL Server 2000 machine, some of the
more complex queries produced this error
Intra-query parallelism caused your server command (process ID #50) to
deadlock. Rerun the query without intra-query ...more >>
Upload Spreadsheet data to SQL Server Table Need Help in Query
Posted by Moe at 2/13/2006 9:18:49 AM
Hi Freinds, I am very new to SQL Server and i have to upload this
spread sheet and the reocords in this spread sheet will go to fields of
already existing record in the sql server table. I am confirmed that i
have to write some kind of query to do that but i am unable to write
this query so fa...more >>
SQL Server could not spawn process_loginread thread
Posted by Steven_Webster at 2/13/2006 9:16:27 AM
I'm running SQL Server 2000 SP 4 (8.00.2162) Standard on Win 2003 SP1, 2GB
RAM, dual 3.00 GHz hyperthreaded processors. I get the above message
intermittently - up to once a week. I have to kill the sqlservr.exe process
to enable SQL Server to restart (or reboot). I cannot connect ...more >>
migrating from MYsql to MSSql2005
Posted by Sap at 2/13/2006 8:29:43 AM
Does anybody know how to migrate form Mysql to MSSQL 2005?
I tried creating DSn`s for repective database butin the DTS wizard My
sql is never selected as a datasource.
Posted by DWalker at 2/13/2006 8:11:38 AM
SQL 2000: I have a DB maintenance plan where one step rebuilds indexes.
I get the following entries in the text log file that the step creates:
Starting maintenance plan 'CDW Backup' on 2/13/2006 1:00:02 AM
 Database cdw: Index Rebuild (leaving 5%% free space)...
Rebuilding indexes...more >>
Need help on DDL triggers in SQL Server 2005
Posted by Learner at 2/13/2006 7:57:49 AM
I am trying to create DDL trigger as below
ALTER TRIGGER DDLTRIGGER ON DATABASE
DECLARE @EventData XML
SET @EventData = EVENTDATA()
Current errorlog not showing
Posted by MarkusB at 2/13/2006 5:56:40 AM
last week I had to move my master database en with it the location of
my SQL Server errorlogs. Since then new errorlogs are created in the
new location specified in the startup parameter, but in EM I can only
see the archived ones, not the current.
Turns out that xp_enumerror...more >>
To Get process info without querying sysprocesses
Posted by Nirupam at 2/13/2006 5:49:20 AM
I am trying to write a query to find the currently logged on users to the SQL
2005 Server. Now the problem is 'sys.dm_exec_requests' shows the database
name only when the process actually starts the execution.
I need to find the session-ids of all processes along with the database
names th...more >>
SQL Server 2005 application development
Posted by Chard-Fi at 2/13/2006 4:31:27 AM
I'm looking to start a project where I will be building a CRM type package
with the intention to sell. Can anyone clarify how the whole licensing thing
works with SQL Server?
Do I buy a developer licence and then I can redistribute the server software?
Would my client need to by CAL...more >>
Migrating databases SQL 2000 to SQL 2005
Posted by GÃ© Brander at 2/13/2006 4:26:16 AM
What sort of problems can I expect when moving my SQL 2000 databases to the
SQL 2005 platform?
Must there be an adaption of code for some of the objects (sp, view, udf
etc), or will it work fine when I put the database compatibility level to 8.0?
Time out expired
Posted by sid_hegde NO[at]SPAM irco.com at 2/13/2006 3:08:41 AM
We have been getting timeouts intermittently with our application. The
time out expired appears to be a random occurance and we are not able
to replicate the issue on a consistent basis. In most instances the
time outs are happening with SELECT statements and after a few minutes
it seems to go a...more >>
Restore SQL databes to diffrent server using Scripts
Posted by Williamc_sircon at 2/13/2006 2:33:34 AM
I hope someone here can point me in the right direction.
We currently have a "Live" server and a "Backup" server both using SQL
We are trying automating the database restore between these servers if
It is currently being done by hand.
We have 40 Databases to recover....more >>
error when connecting trhough enterprise manager
Posted by kryshzt at 2/13/2006 12:40:29 AM
hi all ,
i've got an application with sql databse. it runs correctly on the server.
when i go to windows Xp and installed the appliaction and run the sql
enterprise manager to connect to the server, i get the following error:
message =: ExecuteReader requires an open and available connecti...more >>
Login setting by IP range?
Posted by Lau Lei Cheong at 2/13/2006 12:00:00 AM
In MySQL we can set to allow a user to login and access certain
table from certain host, is there anything close to that in MSSQL 2000/2005?
Actually, we just need to control certain users unable to use the
Domain Creditial to access certain databases/tables except i...more >>
Is it possible to integrate with VSS?
Posted by Atenza at 2/13/2006 12:00:00 AM
Is there a way to integrate with Visual SourceSafe? Since i want to keep
track the changes of functions, sp, schema... etc.