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
Insert - indentity column - rollback
Posted by mfsumption at 2/1/2006 10:04:27 PM
When inserting a record (i.e. in the midst of a transaction) and an error
occurs and the transaction is rolled back, will the identity column increment
to the next value?...more >>
Determine when a Service Pack was applied?
Posted by wawork NO[at]SPAM hotmail.com at 2/1/2006 9:21:38 PM
We are running SQL Server 2000 with SP3. Is there a way to determine
the date the last service pack was applied?
Xp_dirtree crashs as it seems to have a file limit
Posted by Rog at 2/1/2006 8:27:06 PM
We are using a Window's written 3rd party payroll product called Meridian
here in Australia that uses SQL Server 2000 SP4 (v8.00.20.39). One of the
calls is to the extended stored procedure xp_dirtree (which has the
xpstar.dll at its heart). This payroll application was working ju...more >>
Posted by Juliano H via SQLMonster.com at 2/1/2006 6:43:26 PM
I'm creating a script to collect DataBase Space used and DataBase space Total
and after that I will store this information in a table in my SQL Server.
I've tryed using sp_spaceused but I don't know how to use the result of this
If anyone know how to get this infor...more >>
SQL Server Network Utility - No protocols listed SQL 2005
Posted by bababooey NO[at]SPAM yahoo-dot-com.no-spam.invalid at 2/1/2006 5:23:38 PM
Have been trying to figure out a reason for a third party program
being unable to connect to one of our SQL Server 2005 databases.
Here is the situation.
Windows 2003 Standard Box. Initially had installed Windows SharePoint
and everything worked fine
Then installed SQL Server 2005 - inst...more >>
sql2000 backup to samba share
Posted by j.goines at 2/1/2006 4:14:22 PM
1st of all i have to tell that there is NO active directory and NO windows
i try to do a backup from a database to a samba-share on linux over network.
first i map the samba share with "net use" command to a drive letter.
that works, i also can copy file onto it.
but if i ...more >>
Cannot copy indexes w 2005 Import/Export Wizard
Posted by MarkGsch at 2/1/2006 3:48:26 PM
In SQL 2000, the 'Copy SQL Server Objects' task allows 'copy indexes' under
'Advanced Copy Options' when transferring tables. But I cannot see where the
SQL 2005 Import and Export Wizard allows this option. Is there an easy way
to do this (I hope) ?...more >>
Pause Log Shipping for Server Maintenace
Posted by John Oberlin at 2/1/2006 2:59:39 PM
Is there a graceful best practice to temporarily pause log shipping so that
unrelated Windows maintenance can be carried out on the servers?...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Moving tables to new schema
Posted by Chuck P at 2/1/2006 2:57:17 PM
I am using sql05 and need to move some tables/data/keys to a new
schema (same database).
Any easy way to do that?
thanks, Chuck...more >>
Database Maintenance Plan - Can't select Remove Files Older Than .
Posted by DHood at 2/1/2006 1:36:28 PM
Having a strange problem and hoping that someone else has seen this before.
Have an up and running SQL Server 2000 (no problems that I can detect).
Trying to create a maintenance plan to backup the databases each night.
Start the maintenance plan wizard and get to the "Specify Bac...more >>
Change Lincense Key
Posted by Andrew at 2/1/2006 1:25:31 PM
We currently have a SQL cluster which was built on pirated license keys.
This was a managerial mistake let me point out.~
Can we change the license key to legal copy without re-installing SQL? I
see that they license key is stored in the registry, but it appears that the
Product ID is gen...more >>
Figuring out which databases are the most active.
Posted by UJ at 2/1/2006 12:50:27 PM
Is there a way to see which databases are getting the most activity?
TIA - Jeff.
I need documentation re: dedicated SQL Server
Posted by mkerrigan NO[at]SPAM ktoys.com at 2/1/2006 12:09:35 PM
I am searching for some reliable-source documentation regarding why SQL
Server should be run on a dedicated server. Can anyone provide me with
links to such documentation?
Differential data backup sql2k
Posted by mecn at 2/1/2006 11:45:35 AM
I am trying to do the data differential databackup daily and full backup
during the weekend.
Log shipping remain the same as usual.
There is anything that I should be aware of before I chnage the backup
It takes too long to have full data backup every night.
Degraded performance after applying SP4 on SQL 2000 -- repost for no response
Posted by Quentin Ran at 2/1/2006 10:14:27 AM
I am seeing degraded performance after applying SP4 on SQL 2000.
My specific queries (they are in stored proc) access linked server. When
the process is run, I keep seeing blocks on the linked server side among
processes of the same spid spun off from the calling process like this...more >>
Posted by Talha at 2/1/2006 10:04:28 AM
I am a PhD student at UIC and I am stuyding the performance of TPC-C
benchmark over SQL Server. I would appreciate if someone could tell me how I
could obtain the TPC-C benchmark application from Mircosoft?
temp db grows in 5 minutes
Posted by hongo32 at 2/1/2006 10:03:25 AM
hello, i have a problem, we are made test of stress over an application
and the tempdb grow up to 800mb in les than 5 min. exists a form that i
can identify what stored procedure make that this occurs?
Database connection/Access help
Posted by JP Bless at 2/1/2006 9:43:38 AM
My app needs to be installed in 3 locations A,B and C.
All three locations will use either MSDE or SSQL and have Broadband
Internet with static IPs. I want to design the app so user will be able
to search and update database in three locations from either location
(A,B or C). My problem is how t...more >>
SQL gurus, please help
Posted by Raj at 2/1/2006 8:40:53 AM
We have SQL Server whose data is being accessed through crystal reports
and excel spreadsheets (using ODBC driver). I am trying to find all the
crsytal reports ad excel spreadsheets that are hitting a particular
database. I thought SQL Profiler will help me with that. It did to some
Changing Compatibility Level on an Upgraded SQL Server 2000 db to 2005 causing delete to be VERY SLOW
Posted by blam at 2/1/2006 8:07:29 AM
I have just upgraded my SQL Server 2000 to SQL Server 2005 and from
what I understand the upgrade will do the database conversions for you.
After the install I tried to delete a row from my Item table which is a
foreign key to about 10 other tables. A simple
Delete Item Where ItemID = 888
msdb marked as suspect
Posted by Kallu at 2/1/2006 8:01:34 AM
Following error message is displayed whenever i open the Sql Server
Database 'msdb' cannot be opened. It has been marked SUSPECT by recovery.
See the SQL Server errorlog for more information. (.Net SqlClient Data
I am using Sql Server 2005 wi...more >>
Backup Strategy : Microsoft Backup or Veritas
Posted by Chris at 2/1/2006 7:15:03 AM
I am trying to decide if we should use Microsoft Backup (Database Maintenance
Plans) or use Veritas. We already own Veritas, and the SQL clients.
Option 1. Do Not use Veritas SQL client. Use Microsoft Backup to produce a
..BAK file on the SAN. Use the Network install of Veritas (not on SQL sv...more >>
URGENT: alternative to log file being full
Posted by Rob at 2/1/2006 7:02:27 AM
I have posted the following in the 'SQL Server Programming' discussion group;
not sure if it belongs there... so I'm reposting it in this group as well:
I have a 540 million row table; in it, there is a column whose datatype that
I am attempting to alter using the following command:
alter ...more >>
Linked Server Between Domains
Posted by David at 2/1/2006 5:47:45 AM
How do I go about setting up a linked server between a SQL Server 2000
instance in Domain1 to a SQL Server 2000 instance in Domain2. There is a
trust between the two domains and when I log onto the server in Domain1 I can
connect to the server in Domain2.
Any assistance would be app...more >>
Bug in indexed view??
Posted by Space_AD at 2/1/2006 2:03:10 AM
We use SQL server 2000 sp3 database server in Windows 2000 Advanced server OS.
In production environment, one of the fact tables in our datamart has over
150 mil rows. A indexed view is built upon this fact table for reporting
The problem is that when queried for the same criteri...more >>
Identify databases that are not used
Posted by Gary at 2/1/2006 2:00:29 AM
Does anybody know the process of identifying databases what are not used?
This can really help me since in our environment we have numerous databases.
unable to allocate minimum server memory
Posted by Franky at 2/1/2006 1:43:27 AM
I have a cluster of two nodes running Windows 2003 Enterprise Edition with
SQL Server 2000 Enterprise. Each node has 32 GB. And I set the max server
memory and min server memory to 28 GB, but the maximum memory was shown only
16 GB, and SQL Server reports "unable to allocation m...more >>
Backup and restore
Posted by Harish Mohanbabu at 2/1/2006 1:40:29 AM
When I tried to restore a database backup that was created by SQL Server
2000 / SP3a installation into a SQL Server 2000 / SP4, I got the following
error message -
Microsoft SQL-DMO (ODBC SQLState: 42000)
The file on device 'D:...more >>
Posted by Leila at 2/1/2006 1:11:09 AM
I need to get information from a backup file. For example the logical name
of database file (data/log) that exist in the backup set.
I know that RESTORE FILELISTONLY and RESTORE HEADERONLY provide this
information, but I need to get them in variables, or something that makes me
able to u...more >>
SQL Server Logins - urgent
Posted by sc_simsl at 2/1/2006 12:38:30 AM
My SQL server log is flooded with "Login Failed" messages.
SQL profiler trace shows application name = "Microsoft SQL Server". What are
these connections? Why would a SQL Server initiate connections to another
Urgent - please help! Audit issue!
thanks in advance....more >>
SQL for starters.
Posted by jithu.m at 2/1/2006 12:26:07 AM
I am new into database.Can you please help me in getting my queries
solved.I am currently learning oracle basic and looking more into SQL.
Can you please telll what is the difference between oracle and sql.Both
are database but what are the differences between them.
Please support m...more >>
Collation settings for a website in Russian
Posted by Roger Withnell at 2/1/2006 12:17:36 AM
I am using html, vbscript, asp and sql server.
The website is mainly in Russian but may have some English.
The consensus appears to be that it is best to use utf-8, so I plan to use
html charset utf-8, asp codepage 65001 and ntext, nchar and nvarchar
If the above is cor...more >>
Restoration (Database in use!)
Posted by Leila at 2/1/2006 12:00:00 AM
When I want to restore my database, there might be some users browsing the
web site and therefore they have connection to SQL Server. I need a quick
way to kill all of users and perform the restoration. I think I must use
KILL command but instead of writing an script and a cursor, I thoug...more >>
moving transaction logs in sql 2000
Posted by Fazz at 2/1/2006 12:00:00 AM
We have a mission critical database above which we have a crm application
that sits on top of it. In trying to improve the performance of the sql
database I have added another logical disk which is in actual fact another
raid 1 array. I would like to move the transaction log files to thi...more >>