I am testing a security model implementation, but I've hit a roadblock. A stored procedure is owned by dbo in a particular database. It creates a temporary table and inserts using the bulk insert command. When testing with the user for our application, I get an ODBC error that says the table must be owned […]
2001-11-20
112 reads
Hi all Whilst in EE under v7.0 (SP1) I am getting a provider timeout when viewing rows from a view a analyst has created. Does anyone know where this timeout value is set? I know for a fact that it takes 1min (on avg) to run (via query analyser) but times out after 20secs in […]
2001-11-20
6 reads
It seems every couple of months i get an error in my database saying the PRIMARY Filegroup is full. Is there something I can do to keep this from happening?
2001-11-16
1 reads
Hi all of you, I am new SQL Server, I want to connect SQL Server with ASP language and I only want to connect one. As global.asa file, anybody can guide me using global.asa file for connecting SQL Server Thank in advance
2001-11-05
3 reads
any shortcuts to obtaining DDL for a table like a little know system sproc? Anything available in DMO, or scripts in this library to do this? I need to script the DDL for SQL tables. Views and Sprocs are easy as sp_helptext does the job. Brian Lockwood President LockwoodTech Software
2001-11-05
4 reads
Hi all I currently have a 2-way server with 512Mb RAM as my prod database server connected to a disk farm via a 2m RAID controller. The idea was that we can cluster up as need be in the near future as high availability becomes a concern for us with another similar config server. The […]
2001-11-05
3 reads
How can i fetch specific number of records from table? Say a single table has 10000 records without fetching all the records ,if i want to fetch particular number of records say from 400 to 450 ,how can i do that?
2001-11-05
3 reads
How do you send out 1 e-mail for a package that has multiple steps (ex.create table1, connect 1,connect 2, create table2, connect 3, connect 4, create table3 connect1, connect2, create table4, connect3, connect4) If the create on table1 fails (precedence = fail)the creation of table2,table3 or table4 is not done, every thing stops. I'm using […]
2001-11-02
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/sjones/identitylocking.asp
2001-11-02
10 reads
Can I do a DTS import from an Excel file, whereby the package updates those records which already exists in the database from excel and insert new records which doesnt exists from excel to SQL? It will do a comparison by a unique(e.g. username) between excel and my db.(By transformation or stored procedure?) This package […]
2001-10-25
2 reads
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
I recently received a complaint that Query Store for a particular database was turned...
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