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
Quick Help Please
Posted by Bobby Henningsen at 2/27/2006 8:48:02 PM
I've made a demo showing the use of an Event Notification. It has worked a
100 times before but all of a sudden it doesn't !!?? Here's the code and
everything else is in place. I've just installed the server and it's a
Developåer Edition and I'm using the good old Northwind Database. It has th...more >>
Posted by Tale at 2/27/2006 8:01:44 PM
how to change database collation?
SQL2005: Restore Errors
Posted by clintonG at 2/27/2006 8:00:31 PM
While attempting to use SQL Server Manager 2005 to restore Test1 to
Test1Copy1 at least 9 times out of 10 I get the following error:
// Restore Test1 to Test1Copy1
System.Data.SqlClient.SqlError: The file 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\Test1.mdf' cannot be overwrit...more >>
Posted by JIM.H. at 2/27/2006 7:11:27 PM
How is load balancing working in SQL Server 2000. We want to have two
different servers as a back end for our web based eCommerce application. Is
this possible? While there be any modification requirement in the application?
SQL startup hangs for 10 minutes on "attempting to initialize distributed transaction coordinator"
Posted by Mister_Tog at 2/27/2006 6:05:10 PM
We have a SQL service that consistently seems to take about 10-12
minutes to start up. After it finally started, everything is hunky
dory. I was able to review the SQL Server logs in the Enterprise
Manager. The SQL startup hangs on "attempting to initialize distributed
How to do this SQL analysis...
Posted by HK at 2/27/2006 5:06:12 PM
With SQL 2005 Standard: I have records in a table that show how long it
takes to complete a task...
ID_KEY DATETIME (nearest minute) DURATION
When a task is started, a record is added with a "null" duration, and when
the task is finished, the duration is updated to represent the...more >>
QUESTION ABOUT Use Windows NT fibers OPTION
Posted by Mr at 2/27/2006 4:42:26 PM
Why the option Use Windows NT fibers isn`t work in Windows 2003.
What can I do for use this option and use more priority with SQL server?
Using SQL 2000 in Windows 2000 is better. Why?
Please help me.
I have SQL Server 2000 in Windows 2003 using Threads with .NET ...more >>
strange things when moving database
Posted by Per W. at 2/27/2006 4:42:07 PM
When moving from a SBS2000 server with SQL2000SP4 and using detach and then
attach on a new SBS2003server (Prem. edt) with SQL2000SP4 then many fields
behave as date field and there isnt any data in them, any sugestions?
Don't see what you're looking for? Search DevelopmentNow.com.
Posted by tin at 2/27/2006 3:35:02 PM
hi all, i am having a hard time getting the conversation handle id to match ...
scripts that create the relevant objects ...
create message type QueryMessage validation = none
create contract QueryContract (QueryMessage sent by initiator)
create queue QueueSender
create queue QueueReceiver
ful text index
Posted by jj at 2/27/2006 2:55:59 PM
I just created a full text index on a table and everything appears fine but
after populating it I still have an item count of zero. Any ideas?
Transfer data sql2k
Posted by mecn at 2/27/2006 2:44:49 PM
I have 200 mil records in one table need to be transferred from one server
to another server fro test.What is the best way to do the transfer by
passing the log?
move a database to another location
Posted by hershel at 2/27/2006 2:41:04 PM
How do I move a database from one server to another?
Is it a problem that the original server is SQL 2000 and the new is 2005?
Express 2005 - Database Diagram Error
Posted by c_shah at 2/27/2006 2:40:17 PM
Installed adventure works..and when creating a database diagram giving
a message says that it does not have valid owner.
The adventure works database is in SQL 2005 compatibility mode.
Windows Media Services and SQL on same server
Posted by davidwkelling NO[at]SPAM yahoo.com at 2/27/2006 2:16:41 PM
Are there strong reasons not to have SQL Server 2005 and Windows Media
Services running on the same server? It seems SQL is more processor
intensive and WMS is more bandwidth intensive and they might share the
same server pretty well. Sure, if the budget was there, each would get
it's own box b...more >>
Startup Parameter -T 1204
Posted by Cgal at 2/27/2006 1:55:51 PM
I am working with the RTM Standard Edition of SQL Server 2005 and Deadlock
trace output is not getting written to the error log. I use the -T startup
parameter and specify -T1204; -T 3605. I set the startup parameters using
the SQL Server 2005 Configuration Manager. I then restart the SQL S...more >>
Question on Application roles.
Posted by ChrisR at 2/27/2006 1:40:30 PM
Im comparing a username/ password to an App role/ password and Im just not
seeing the logic here. An App either needs to supply a username/ password or
a "sp_setapprole @rolename = 'TestRole' ,@password ='test'". Either way they
are granted access to the DB. Either way they can only e...more >>
Posted by sorourke1 NO[at]SPAM hotmail.com at 2/27/2006 1:40:29 PM
I am attempting to exports the results of a stored Procedure into a CSV. The
table is a temp tabel named #FinalPrivate. I need to allow a user to download
the file from a .NET Web Application. Is there someone that can point me in a
Number of Objects and Performance
Posted by Sierra at 2/27/2006 1:32:28 PM
How does the number of objects (specifically tables) affect overall
performance of SQL Server?
Does SQL Server slow down as more objects are added - even if the overall
data size remains relatively the same?
How significant is this slowdown? Is it noticible after thousands of
objects, mi...more >>
Multiple Instances on a cluster
Posted by sean.frenette NO[at]SPAM umassmed.edu at 2/27/2006 12:43:14 PM
I currently have a 2-node, active/passive cluster running SQL Server
2000 w/SP4, running just the default instance. I am looking to add a
2nd instance, but I have a couple of questions on how to start:
1) I understand that you have to re-run the install and create the 2nd
instance. I've alre...more >>
Memory Allocation - Win2k3 SP1 and SQL Server 2K SP4
Posted by nicholasbecker NO[at]SPAM gmail.com at 2/27/2006 11:45:40 AM
I have a SQL Server cluster with 4 Dual Core 3.0Ghz Processors and 8 GB
of RAM. I have PAE and AWE enabled on the server, but I cannot get SQL
Server to access more than 4GB of RAM (using perfmon- SQLServer:Memory
Manager/Total Server Memory). I would like to allocate nearly all of
the ava...more >>
Sending SMTP email
Posted by viktor at 2/27/2006 10:59:23 AM
I am trying to send SMTP email with attachment using cdosysmail and getting
error on this line:
EXEC @hr = sp_OAMethod @MailID, 'AddAttachment', NULL, @FileSource
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should...more >>
How many Enterprise Licenses to Buy?
Posted by DaveK at 2/27/2006 10:51:27 AM
We are building up a clustered server configuration with two nodes. Each
node will be an HP ML580 or DL 580 with 4 processors per server. Do we need
to buy two Enterprise licenses (one for each 4-processor server) or 8
licenses (one for each processor on each server)? I am getting conflicti...more >>
Determine used fields/tables in database
Posted by Kyjan at 2/27/2006 10:42:41 AM
Greetings to all!
I was curious if there was a way to determine what fields are in use by
stored procedures and/or views in a database. If there's a way through
SQL or through VB .NET, I would be most appreciative to learn about it.
Rename a table sql 2k
Posted by mecn at 2/27/2006 9:28:51 AM
I am trying to rename a table, it gives me this error,
Object 'Test' cannot be renamed because the object participates in enforced
How do I rename a table then create a new table with the original name.
SQL 2005 Server Properties - Language
Posted by Karen at 2/27/2006 8:43:26 AM
I have just installed a new SQL 2005 server on a Windows 2003 server with
regional settings set to English (United Kingdom). Despite the setting on the
underlying server the SQL 2005 server displays it's language as being English
(United States) in the server properties screen (greyed out).
any stored procedure to report all the databases' information
Posted by bing at 2/27/2006 8:41:04 AM
We're going to migrate our SQL 2000 server from one domain to another. I
need to get a better idea of how our current databases are structured and
utilized. What I want is a report showing each database's:
if backed up or not
Before I ...more >>
is it better to use Begin-Commit?
Posted by jouj at 2/27/2006 7:19:31 AM
is it better to use Begin...Commit in all SP?
does this help preventing deadlocks?
thanks in advance.
sql server 2005
Posted by farshad at 2/27/2006 6:09:12 AM
I am trying to script the creation of the Stored Procedures.
But can not get the script to have the bits for if exists then drop bit.
How to pivot on two field
Posted by ad at 2/27/2006 5:33:00 AM
I have a health check result table for students in a primary school.
The table is like below.
I use pivot to count the students count for every resultID:
Select GradeID, Gender , AS r1, as r2 , as r3
(SELECT CheckID, GradeID, Gender, ResultID
FROM [Result]) p
Ntext replication - Max size exceeded
Posted by Sanjay at 2/27/2006 4:42:29 AM
I am facing one wierd problem.
I have one table having column as Ntext, from front end we are inserting
50000 characters.Replication is enabled , when we are inserting 50K
characters we are getting error
"Length of text, ntext, or image data (100000) to be replicated exceeds
Is this a bug in SQL 2000/2005?
Posted by Florin Lazar at 2/27/2006 3:50:27 AM
Running the script below the error number is not generated and the
transaction is rolled back ...
Should be like this, or it should nicely give the error number and let me
decide what to do?
This is very usefull when using EXECUTE() or sp_executesql().
Here is hwo you can reproduce the prob...more >>
SQL2000 rebuildm - wrong path
Posted by hubi777 at 2/27/2006 3:47:29 AM
I have installed a backup server with the German version of Windows2000 and
By default, all program files are stored in the folder
â€œc:\Programme\Microsoft SQL Server\â€¦\Data\â€.
If a rebuild the master database with the rebuildm utility, the files are
copied to the â€œProgr...more >>
Running updates - the quickest approach - please help.
Posted by almurph NO[at]SPAM altavista.com at 2/27/2006 3:34:00 AM
I have to update a column with about 1.34M rows. The column is a a
primary key and hence has a clustered index associated with it. I have
to run updates o nthis column.
Would it be quicker to do the following:
1. Delete the index
2. Run the updates
3. Recreate the index
Posted by Serri at 2/27/2006 2:58:35 AM
we have application and customized it by using VBA
In VBA Code i run some queries witch summrize some information
we plan set the query in stored procedure then we execute it from VBA
insted of run query from VBA
so how this will effect in performance
Thank you for your help
problem with date time field ...
Posted by zerbie45 NO[at]SPAM gmail.com at 2/27/2006 2:55:00 AM
I have an asp page that needs to show data based on date criteria.
Basically the user selects a date and the asp page should display all
records within that day.
The problem is that this field contains date and time.
My current query is as follows:
RS.Open "Select * from DB1.dbo.l...more >>
Trigger or SP
Posted by Adarsh at 2/27/2006 1:06:15 AM
I have a situation in which a record in inserted into a table say
table1 when any record is inserted in any table in the whole
application. Is it better to use trigger or to write the insert query
in the SP for every table itself.
enterprise manager 2005
Posted by chriske911 at 2/27/2006 12:00:00 AM
can I use enterprise manager 2k5 for adminestering sql 2k without any
Changing location of the error log file
Posted by Nancy Lytle at 2/27/2006 12:00:00 AM
I am a defacto DBA and we have a 2 node clustered (active/passive) SQL
Server. When SQL Server was installed the error log file location used was
the default location. That path lists the local share and not the shared
cluster path. Now if the server has to fail over to the other node, SQL