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
Previous machine name in Profiler
Posted by Peter CCH at 2/19/2006 9:58:32 PM
I changed the machine name yesterday (from Machine1 to Server1).
I'd delete the SQL server registration in Enterprise Manager and
register again with the new server name - Server1.
Everything run correctly.
But when I open the Profiler, create a new trace, I use (local) when
"Connect to SQL...more >>
How to identify when the values are going on particular record
Posted by SouRa at 2/19/2006 9:08:26 PM
I want to identify, when the values are modified/updated on the particular
row in a table, i am not using triggers in this table.
Please advise me, any options in SQL Profiler Trace to find out this.
Posted by Spin at 2/19/2006 8:01:06 PM
I have a standard SQL 2000 installed onto a Windows 2003 Server on which I
am a local administrator. An IIS server by way of ASP.NET uses this SQL
database server as it's back-end. Someone told me there is a way in SQL to
see who is using the database via the ASP>NET front-end on...more >>
A Challenging Question
Posted by Double_B at 2/19/2006 7:40:35 PM
How does one figure out, I mean compare the results after some changes
have been done to the SQL Server, I mean the method in which the
comparision is done, lets say I have a query I ran it it gave me the
results in 40 seconds , I ran it again this time it took 30 seconds,
then I again ran it it...more >>
Specify which table to store in which filegroup
Posted by Peter CCH at 2/19/2006 7:34:36 PM
How do I set/specify which table to store in which file group?
Let's say I have 3 data file (1 primary and 2 secondary). I want system
table to stored in primary data file, mostly used for reading tables
stored in secondary data file 1, and transactional tables stored in
secondary data file 2....more >>
Your favourite SQL hardware!
Posted by davemateer NO[at]SPAM gmail.com at 2/19/2006 5:58:51 PM
We are in the process of putting in a new SQL Server box. Initially
running 2000, then probably 2005 quite soon.
Thought it would be good to see what hardware you run, and if you like
Our box will be doing heavy nightly importing of data then cube
processing (to be accessed v...more >>
Copy SS2005 query headers & data to Excel
Posted by Steven K0 at 2/19/2006 2:36:31 PM
Using SS2005, is there a way to copy both the headers and the data when you
run a query and paste the results in Excel?
Thanks in advance,
1.5 GB in Lock Memory
Posted by Hassan at 2/19/2006 11:08:47 AM
And I am getting errors in the log indicating that Lock resource cannot be
Why does SQL Server not decide to escalate the lock amd release some memory
and cause other apps to throw the error.
There are a lot of fine level key/row level locks consuming the memory. Do I
have to j...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
query or stored procedure to insert values into pr. key field
Posted by bubbahotep at 2/19/2006 10:27:15 AM
I have an existing table with the following fields:
tbl_users: this table has all the data
and the second table:
tbl_notes: this table may or may not have a matching record with
database maintenance plan using T-Sql and current_timestamp
Posted by blueboy at 2/19/2006 6:17:05 AM
hi can anyone help, i have a database maintenance plan which is set to
run hourly at the moment it overwrites the current database but i want
to append it with a current_timestamp, here is the T-SQL i am using
BACKUP DATABASE [company name] TO DISK = N'E:\Hourly
Backup\Company\Company backup-...more >>
Need advice how to write a program to receive an image via email and put it into the SQL Server database
Posted by Vanessa Lee at 2/19/2006 3:44:12 AM
I am trying to find a way to write a program to do the following:
Receive an image via email, retrieve that image and put it into a database.
Could you please give me an advice where to start or point me into the right
direction? Is there an ASP component somewhere that would do the...more >>
SQL Server Unable to log "error"s in the EventViewer-Application Log
Posted by sasiraj at 2/19/2006 1:29:31 AM
I am having a problem here...
SQL Server is unable to log "error"s in the EventViewer though it is
able to write the
"Information" messages. The server is able to write to the SQL
Can someone give the reason why this is happening??
**find related objects**
Posted by R-M at 2/19/2006 12:00:00 AM
I'm working with SQL 2000, how can I find login name L1 is the owner of
which objects() in which dbs?in other word, when I want to delete a login
name in login list an error appears with the context of "you can n't
delete it because it's owns some objects in some DBs".
any help wou...more >>
Posted by R-M at 2/19/2006 12:00:00 AM
I am working with SQL 2000 and I have a resotred database with these users
in branch of its users :
but in other databases I have the following list:
I ...more >>