Could you please help me figure out my problem. When I login as a sa and set IDENITITY column ON for a table. Insert works with no problem. When a want to do insert into the same table using Stor proc with the IDENTITY SET still ON I am getting error message: Cannot insert explicit […]
2001-10-26
We have an external web server that attaches to an internal SQL server via a specific port. When the user submits info from their browser, we want to send it to SQL server, run a program that massages the input into a pdf file, and finally send the pdf file back to the user (via […]
2001-10-25
1 reads
Hello Everyone, In SQL Server 2K, is it true that default instances support all net-libraries while named instances only support Named Pipes, NWLink IPX/SPX, TCP/IP, and Shared Memory net-libraries? Do named instances not support Apple Talk net-libraries? Thanks! Jube
2001-10-24
1 reads
How do we remove an identity, from a sql table column which already has identity and data , without loosing the data and without having the need to copy data to new table
2001-10-23
1 reads
Hi all, I understand that only if we backup the database, the log space is freed. This is regardless whether the truncate log on checkpoint option is true or false. My doubt is, i found somewhere that this option (truncate log..) should not be set to true. If set to true, then, all the transaction […]
2001-10-22
Running a script automatically from SQL Server is easier than you think. Here are a few methods you can use.
2001-10-17
15,842 reads
How to direct the SQL query output to a file for a query like select * from test1
2001-10-12
4 reads
Hi all A programmer recently asked me if I can "reset" an identity column on a specific table to start from a specific value. The case is where we have a reference data table with values: 0 1 2 3 if we insert a new row SQLServer gives us 8 instead on 4 as previous […]
2001-10-08
1 reads
I want to send 10000 email at a time from asp for that i had used cdonts object but after sending 1000 email i am getting error please tell me how to solve the problem vijay verma
2001-10-04
2 reads
On SQL Server 2000. I don't know if this is possible, though I am only a developer, and don't have a great deal of knowledge about backups. Some data was inserted into a table (we NEED this data!) and an old entire backup was restored over the existing dB, unfortunately this occured a few hours […]
2001-09-26
2 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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