RE: Strange error from QA
Hi eletuw, I get this running when I remove the LOCAL FAST FORWARD option. Hm, now I only need to figure out, what this is doing? Cheers, Frank
2003-06-18
maintenance
RE: Strange error from QA
I made the chnages but still got the error. I am psoting the entire query in cae it might help. ========================================== DECLARE @ID INT DECLARE @Name varchar(200) DECLARE @Text nVarchar(2000) DECLARE @cDate datetime DECLARE @ColID int DECLARE @Type varchar(10) -- Declare the cursor DECLARE CURSOR_OBJ CURSOR LOCAL FAST_FORWARD FOR SELECT TOP 100 PERCENT dbo.sysobjects.id, dbo.sysobjects.name, […]
2003-06-18
RE: NT's System Monitor
I do this using a tool called typeperf. However typeperf can be a headache because you have to send a keystroke to the console to exit. So what I have is a dts package that using a vbscript to execute typeperf and send a keystroke. Then I I have another package that modifies the csv […]
2003-06-17
2003-06-17
RE: switching off the identity on a column
Ok, I went back to BOL and looked at the syntax. The IDENTITY option is only available if you are adding a column. ALTER COLUMN allows you to add or drop ROWGUIDCOL but not IDENTITY. EM does it by creating a new table with the IDENTITY property, copying the data to it, dropping the old […]
2003-06-17
RE: switching off the identity on a column
As a final note, you may want to go into Enterprise Manager and change the table in the Design View, then click Save Script button and see what SQL internally thinks is the best method for handling this...Sometimes this technique is useful in figuring out some of the trickier DDL constructs... Good luck!
2003-06-17
RE: Stored Procs & Variables
Thanks too jpipes. Think that would work too. I just figured this out and it seems to work, this is what I've done: ....Get the field names into a rs as @FieldName then loop.... DECLARE @RetrievedValue nvarchar(50) , @sql nvarchar(1000), @col sysname, @colVal varchar(50) SELECT @col = @FieldName SELECT @sql = N'SELECT @colVal =' + […]
2003-06-13
RE: ConnectionRead (recv())
Problem Solved. After running a packet sniffer for a while I discovered that there was an ARP request for the IP of the database server right before the problem. So as it turns out there was a network camara sharing its IP address. The camara was on the same network segment so its ARP request […]
2003-06-11
11 reads
RE: What makes a good developer?
A cold beer is only not allowed when caught. Hint: Fill your coffee cup with beer. When was the last time someone actually looked in your coffe cup to ensure you were drinking coffee? Cheers, Crispin
2003-06-11
RE: Decimal versus Money and division
Hello BillyWilly, quote: No big deal - I'll just do some casting during division to get the 12 precision I want - just found this to be interesting. it is interesting! For further information on decimal data type see http://standards.ieee.org/reading/ieee/std_public/description/busarch/854-1987_desc.html or http://www2.hursley.ibm.com/decimal/decbits.html . Hope this will feed your appetite for information Cheers, Frank
2003-06-10
1 reads
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers