What program and are other clients having this trouble? K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
2003-06-02
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-06-02
Ok, I am new to SQL Server and DBs and I tried the following INSERT INTO db2..mytext (Spanish) SELECT Spanish FROM db1..mytext However, I get the following error message: Cannot insert the value NULL into column 'ID', table 'db2.dbo.mytext'; column does not allow nulls. INSERT fails. The statement has been terminated. ID is the primary […]
2003-06-02
This could be due to a known issue with SP3. If Perfmon is active on the machine running SQL Server at the time the SQL Service is started, you lose the counters. If you shutdown Perfmon and stop and restart SQL Server, they should come back.
2003-06-02
1 reads
Hi Rolf, after reading what php fopen() does, I think the FileSystemObject might be equivalent to it. I'm not sure if this will work on a remote site, but you can use an ActiveX Script Task with this script. I've found this in MSDN '********************************************************************** ' Visual Basic ActiveX Script '************************************************************************ Function Main() Const ForReading […]
2003-06-02
From SQL BOL quote: sp_lock Reports information about locks. Syntax sp_lock [[@spid1 =] 'spid1'] [,[@spid2 =] 'spid2'] Arguments [@spid1 =] 'spid1' Is the Microsoft® SQL Server™ process ID number from master.dbo.sysprocesses. spid1 is int, with a default of NULL. Execute sp_who to obtain process information about the lock. If spid1 is not specified, information about […]
2003-05-30
2 reads
Make the next test on Advanced SQL Server topics, such as replication, linked servers, etc. These tests are very helpful in gaining insights to lesser paid attention topics.
2003-05-29
2 reads
I liked the test...I'm disappointed in what I don't know...but I keep learning everyday. ON the question 14 about changing your SQL Server login's password, I chose the wrong answer because there wasn't a (') after MYLogin and so I figured it wasn't the correct answer. Otherwise, Thanks and keep them coming!
2003-05-29
1 reads
quote: What are you trying to work around? If you post the Jet code, we can translate it to T-SQL... It's alright, I've tried using Min & Max and it all appears to work fine. Thanks fellas.
2003-05-29
This is really a good test. I liked it. The permissions question makes more scenes to me, as it perfectly describes one of my clients company. We used to spend hours of time to figure out where it’s going wrong and finally decided to design a new security plan instead of going through the mess.
2003-05-29
1 reads
A reader of one of my previous posts pointed out that the legend order...
By Steve Jones
Often I see running totals that are written in SQL using a variety of...
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers