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
Problem Attaching Database (I haven't Detached it)
Posted by Camper Joe at 2/28/2006 10:13:26 PM
I had an operating system reload without detaching my SQL Databases.
Now it seems I can't reattach it. This is probably for security, right.
Anyway past it?
Posted by Adarsh at 2/28/2006 10:04:11 PM
This code gives me error:
CREATE FUNCTION [dbo].[InsertUserNotification]
problem restore database SQL2005
Posted by Ving at 2/28/2006 7:31:48 PM
I'm trying to restore a database saved last week in a .bak file through the
GUI of Management Studio but i have the following message error : "the
database is in use".
So i restarted the service engine SQL and changed the option to put Single
User but i have still the same erro...more >>
Posted by Zeca at 2/28/2006 5:20:09 PM
I install SQL Server 2005 trial edition, and there is no Management Studio?
I know i can download the one that comes with the express edition, but that
one do not have all features...
Possible to Insert Records into ODBC Data Source from Stored Procedure?
Posted by Mike at 2/28/2006 5:07:00 PM
I would like to insert records into a non MS-SQL database that I can connect
to with an ODBC data source.
This is possible? If so, can you give me an example of how to connect?
Passing variable to trigger
Posted by Rick at 2/28/2006 4:37:26 PM
I have add/edit/delete triggers on a SQL Server 2005 table.
Before updating that table, I'd like to be able to set a variable that
the trigger can read and that only has a lifetime of that connection or
I cannot include the variable in the update stored procedure.
I tried cre...more >>
SQL2005 - not documented triggers behavior change
Posted by RADl0PASlV at 2/28/2006 4:08:26 PM
I have a simple table with trigger, for example:
CREATE TABLE T(V VARCHAR(100) NULL)
CREATE TRIGGER TR ON T FOR INSERT AS
On MSSQL7 or MSSQL2000 INSERT runs without any messages. On MSSQL2005 INSERT
Server: Msg 3609, Level 16, State 1...more >>
Posted by Niles at 2/28/2006 3:31:53 PM
I am upgrading SQL servers to SP4, are there any issues to look for?
Don't see what you're looking for? Search DevelopmentNow.com.
Importing database from Access to SQL Express
Posted by reidarT at 2/28/2006 3:23:06 PM
How do I import tables from an Access database to a SQL Express database?
Why does sa suddenly not work?
Posted by UJ at 2/28/2006 2:40:53 PM
I have a web site on a clustered server. One server is hosting the website.
Occasionally we get the following error message:
Login failed for user 'sa'.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more inform...more >>
Append to text type field in an update statement.
Posted by reachmandar NO[at]SPAM gmail.com at 2/28/2006 1:55:24 PM
I have a table with one text type column. I am trying to append this
coulmn with whatever it has with another string. This field may have
more than 8000 characters already
here is What I am trying to do.
Set textTypeColumn = textTypeColumn + ' XXXXXXXXXXXXXXXXXXXXXXX'
id = id...more >>
Tracking invalid log-ins ... in 2005
Posted by UJ at 2/28/2006 1:46:35 PM
I want to be able to track when somebody tried to log in with an invalid
userid or password. How do I do this?
TIA - Jeff.
Rewriting a query causing lock escalation
Posted by Steph at 2/28/2006 1:21:15 PM
I've identified a query that is causing deadlocks in our database. The
SELECT portion of this query seems to be causing lock escalation - causing
the whole RECORDS table to lock - and causing other processes to deadlock.
I'd like to somehow rewrite this query to decrease the lock escala...more >>
how to tell when a database was lasted accessed by general users?
Posted by bing at 2/28/2006 1:20:29 PM
In the Subject, by general users, I meant those users who did regular
database operations, like insert, update, delete, etc. rather than the users
who have special privileges to do database maintenance operations, like
backup. We need to clean up those databases that haven't been acces...more >>
Possible to overuse WITH (NOLOCK)?
Posted by CAnderson [MVP] at 2/28/2006 1:16:26 PM
I'm working with a process that is initially invoked from VB, but runs
through a set of stored procedures. The first four levels of the calls are
simply gathering data that the other levels below will need and aggregating
some of it. This data is used to determine if further processing is need...more >>
copy 7.0 database to 2005
Posted by Pete at 2/28/2006 1:14:27 PM
What is the best way to copy a SQL Server 7.0 database to SQL server 2005.
Currently we backup the 7.0 database, restore it to 2000, backup the database
on 2000, restore it to 2005. Is there a better way to do it? And can it be
...A little background.. Our production ...more >>
sql database restricted growth limit notification
Posted by mp3nomad at 2/28/2006 12:57:28 PM
Is there a way to setup a job in sql server 2005 to notify me if a database
is getting close to reaching it's restricted growth limit? For example if a
database is limited to 140 mb... can I setup something in sql server to
noitfy me if the database gets within 90% of it's restricted growth li...more >>
SQL 2005 database mirroring and SQL standard edition
Posted by GS at 2/28/2006 12:55:08 PM
I can see in footnote for SQL 2005 standard edition that mirroring is =
only available for "
2 Local Machine, same SQL Server Edition, relational data only. =20
What does it mean "Local Machine"?...more >>
Bulk Insert Error
Posted by Neal at 2/28/2006 12:32:12 PM
I'm getting the following error when running a BULK INSERT via T-SQL:
Server: Msg 4866, Level 17, State 66, Line 1
Bulk Insert fails. Column is too long in the data file for row 1,
column 3. Make sure the field terminator and row terminator are
Server: Msg 7399, L...more >>
Parameters to insert data from form into SQL database
Posted by hery NO[at]SPAM infoventures.com at 2/28/2006 10:44:23 AM
I'm having problem inserting and storing data from asp.net web form to
SQL database. I use the following parameters for the SqlCommand object
to do the insert:
cmdTest.Parameters.Add(New SqlPara...more >>
Compare Dates Fields
Posted by sck10 at 2/28/2006 10:08:23 AM
I have a table that has 3 date fields. I need to compare the 3 against each
other and get the max date. What would be the best way to do this,
function, case statement in a stored procedure? If there is any code
available, I would greatly appreciate it.
Thanks in advance,
Processes blocked on tempdb resources and can't rollback
Posted by pshroads NO[at]SPAM gmail.com at 2/28/2006 8:15:16 AM
I have a strange situation. A SPID is blocking 3 other SPIDs. The
blocking SPID's lastwaittype is PAGELATCH_UP and the waittype is 0x0413
(Update buffer page latch). The waitresource is 2:1:444 indicating
something in tempdb.
The blocked SPIDs all have the exact same lastwaittype, waittype and...more >>
SQL Server Desktop Engine
Posted by XxLicherxX at 2/28/2006 7:27:44 AM
I have installed the SQL Server Desktop Engine on a server. I know this
doesn't have a GUI, but I am wondering if there is a way to interface
with this. I have seen Microsoft KB articles that require you to be
able to change things with the SQL server, however, these always refer
to MS...more >>
basic Server setup and user accounts
Posted by Steve Scott at 2/28/2006 7:10:32 AM
I have just installed SQL server 2005 standard edition - how do I create a
basic server and user accounts in order to then install Project Server? ...more >>
When is SQL 2000 going ot of suppprt
Posted by MikeAn at 2/28/2006 7:08:28 AM
When is SQL 2000 going ot of suppprt?...more >>
Order by clause help
Posted by accyboy1981 at 2/28/2006 7:03:57 AM
I have a table that contains approx 2000 rows where a timestamp is the
primary key. I want to search between two dates and return the results
order by the timestamp in descending order. The problem arises as I
only want to return a maximum of 50 results starting with the oldest.
E.g. if I...more >>
MemToLeave area! How to monitor?
Posted by james at 2/28/2006 6:52:18 AM
Occasionally I get the error of "WARNING: Failed to reserve contiguous
memory of Size= 65536."
What is the unit for this size, is it bytes or KB? Additionally,
I have set up 511 MB for MemToLeave area by adding -g384 for Sql2k SP3a on
AWE enabled system. I have total of 16 GB of RA...more >>
SQL SERvER Security question
Posted by Tejas Parikh at 2/28/2006 5:57:27 AM
I've a problem with permissions.
There are a few Production SQL servers. One of the guys is a SYSADMIN on
server A only. And 2 of the other users(including me) on that box r sysadmins
for all the boxes. If this user creates a JOB on Server A to do some stuff on
Server B and makes me the owner...more >>
Posted by bijupg NO[at]SPAM hotmail.com at 2/28/2006 5:44:09 AM
I am facing a problem with sql server 2000 sp3 backup to network.This backuP
is as part of scheduled backup to another server in the same network and was
working fine for the last 3 yrs But Recently the backUP is failing with
BackupMedium::ReportIoError: write fai...more >>
Restore DB - SQL Server 2000
Posted by darren.daniel NO[at]SPAM iclployalty.com at 2/28/2006 5:04:16 AM
I made a release on system at 12pm 22/02 and overwrote a table by
I have a back from from the night before (12 at night) but from the
time I did a backup and and the time I did the release some records
would be lost.
I want to recover the data lost.
Can I examine the tr...more >>
ORDER BY is very slow when querying linked Server Oracle9i
Posted by ln54 at 2/28/2006 4:51:28 AM
I am creating 3 views from the linked server
and then I have a question at the bottom returning results.
If I exclude the ORDER BY from my question the query will take about 40
with the ORDER BY it takes about an hour to finish.
Is this normal ??
CLR SP Execution
Posted by Alistair Harrison at 2/28/2006 4:28:22 AM
I am currently working on an application which calls some CLR stored
procedures in SQL Server 2005. The first time one of the CLR stored
procedures (it doesn't matter which one) is called it takes a lot longer to
execute. After the first CLR stored procedure has been executed the CLR...more >>
OUTPUT Clause SQL Server 2005
Posted by Adarsh at 2/28/2006 3:33:25 AM
When I add WHERE CLAUSE IN UPDATE query the OUTPUT Clause doesn't work.
This code works :
DECLARE @OldProposal TABLE
UPDATE tbl_Proposal SET ProposalDesc = 'yu'
OUTPUT Deleted.ProposalDesc INTO @OldProposal
SELECT * FROM @OldProposal
and this cod...more >>
big problem on sqlagent
Posted by jytjyt at 2/28/2006 2:33:23 AM
2006-02-24 02:54:07 - !  unable to start thread JobManager ......
2006-02-24 02:54:20 - !  Erreur ODBC : 0, =C9chec SQLAllocHandle du
pilote sur SQL_HANDLE_DBC [SQLSTATE IM005]
2006-02-24 02:54:20 - !  La connexion au serveur =AB (local) =BB a
=E9chou=E9 (SubSystemStepHistoryLogge...more >>
Recovery options when the transaction log is unavailable
Posted by Oskar at 2/28/2006 1:47:29 AM
On MS SQL Server 2000 SP3, what are my recovery options when only the
database transaction log becomes unavailable and when there are active
transactions in the database?
Sp_detach_db/sp_attach_db/sp_attach_single_file_db doesn't work in this
scenario, I have tried that.
Are there an...more >>
Activity Captured by profiler
Posted by Double_B at 2/28/2006 1:22:28 AM
Does the profiler catch every activity on the server. I mean what about
the various username & password screens , dont you think then its a
threat to security .
& I wanted to knw how to get the last 10 SQL Statments issued by the
users client to the SQL Server.
dbcc inputbuffer (spid)...more >>
Posted by vnegri NO[at]SPAM gmail.com at 2/28/2006 12:22:57 AM
A client of mine recently discovered that certain records were deleted
on their SQL 2000 server. Is there a utility that I can use to look
back at the transactions to find out what happened to those records
(i.e. who/what deleted them and/or what time)?
log backup not getting rid of 'free' space, why?
Posted by peter at 2/28/2006 12:20:29 AM
Hi everyone, I was hoping someone could help me.
I am having problems with my transaction log not shrinking after a log
backup has taken place. The log backups are usually of size 400 Mb at
7:00am and generate further 6 MB (approx.) log backups each half hour.
The log file is usually of size 3...more >>
to monitor user logins/logouts
Posted by maxzsim via SQLMonster.com at 2/28/2006 12:00:00 AM
Hi All ,
This link is from a previous posting
http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm and i followed
the instructions .
I am looking for logins & logouts and i have successfully created the trace
based on the scripts. however, the trc file is always 0 kb despite me l...more >>
turn off logging?
Posted by mmiller at 2/28/2006 12:00:00 AM
Is there any way to stop SQL Server 2000 from logging? It is absolutely not
in my app.
Is SQL Server 2005 any different?
Thanks very much for your time,
"Don't look back. Something might be gaining on you" - Satchel Paige
Posted by P Platan at 2/28/2006 12:00:00 AM
I am having a problem concerning collations.
I have an SQL Server 2000 with Latin1_General_CI_AS
which contains the company data.Some of the fields are Greek and although I
cannot view them correctly in the Query Analyzer , the tool we are using
(powerbuilder) displays them OK.
now t...more >>
Linked Server error in Windows2003Server
Posted by Curtis Kam at 2/28/2006 12:00:00 AM
I've got this error message on creating the linked server to the SQL Server
2000 (in Windows 2003 Server),
"Error 18452: Login failed for user 'sa'. Reason: Not associated with a
trusted SQL Server connection."
The client side is MSDE 2000 (in WinXP Pro).
But I can successfully c...more >>
page life expectancy=0.000
Posted by Marek Wierzbicki at 2/28/2006 12:00:00 AM
In my MSSQL server 2000 sp4, in performanece monito, buffer memory, page
life expectancy is equal to 0.0000 (average for 10 sec, auto update). I
think sth is wrong configured, but what?