sql-server

Canceling report run via Microsoft.Reporting.WebForms ReportViewer

Is it programmatically possible to cancel a long-running report that has been started using the web forms ReportViewer control? Documentation of .Reset() method says "Call the Reset method to cancel any current rendering and reset the ReportViewer control to its default state." However if I (for example) put a button on the web form to...

Best way to do serializable updates to a table

I'm a long time Firebird user and it has a feature called Generators (I think Oracle also has it and it's called Sequences). I'm new to SQL Server and I need to simulate the same feature. I can't use an identity field to solve my problem. I need a named series of values, not a unique number for each row. My biggest concern was about mor...

How do I place a hyperlink on every page of a SSRS 2005 report?

I am building a SSRS 2005 report that has potentially multiple pages. I would like to put in a hyperlink so that it appears on the top of every page. The hyperlink links back to the same report - basically I have a "summary" and "detail" mode and want to have hyperlinks to switch between. So far I tried two approaches: Put a textbox ...

Best way to speed up MS SQL server

I was wondering if anyone has some general sys admin questions on how best to setup MS SQL server for speed. I have placed the log files on a different drive with its own controller and moved the indexes to their drive but on the same controller as the main data files. What other way can a system admin setup MS SQL server to speed up di...

SSRS Email Subscription Configuration

I was trying to configure Sql Server Reporting Services 2008 to send out email when subscriptions were created. I was running SSRS in Native Mode. Whenever I tried to create a new email subscription this error message would appear in the log files: library!ReportServer_0-3!14e4!01/30/2009-12:58:52:: Call to GetSystemPermissionsAction(...

Debugging CLR proc exception problem.

Hi, I get a transactionabortedexception when I run a CLR proc in debug mode and no line number information or anything to help with where the exception is. I am running VS2008 and SQL 2005. how do you debug it? Malcolm ...

Disable hyperlinks when exporting SSRS report to excel

I am using the ReportViewer control to render some local reports. These reports have some elements that are links to supreports. Some of these elements contain a lot of data ( to be passed as arguments to subreport). The problem is when i export the report to excel, it wont open in excel because of the cell max character limit. I am wond...

MSSQL record date/time auto delete

I want to delete records from a db table based on a time-stamp for each record. I would like to have it automatically delete records compared to a date/time interval without user intervention or admin intervention. What would be the best way to go about this, I could create a process that runs in the background that does checks but that ...

SQL Server Procedure returns multiple tables - Insert results into tables

I have a procedure that returns multiple tables; eg: PROCEDURE Something AS BEGIN SELECT 1,2,3 SELECT 4,5 SELECT 9,10,11 END I would like to take each table from the result and insert it into a series of tables/temp tables - one for each record set. Is this possible? ...

Should you choose the MONEY or DECIMAL(x,y) datatypes in SQL Server?

I'm curious as to whether or not there is a real difference between the money datatype and something like decimal(19,4) (which is what money uses internally, I believe). I'm aware that money is specific to SQL Server. What I want to know is if there is a compelling reason to choose one over the other; most SQL Server samples (e.g. the ...

Performance implications of sql 'OR' conditions when one alternative is trivial ?

I'm creating a stored procedure for searching some data in my database according to some criteria input by the user. My sql code looks like this: Create Procedure mySearchProc ( @IDCriteria bigint=null, ... @MaxDateCriteria datetime=null ) as select Col1,...,Coln from MyTable where (@IDCriteria is null or ID=@IDCriteria) ... and (@Max...

After insert, update trigger not running [solved]

I have two triggers After Insert or Update and Instead of Insert. It appears that the after trigger is not running or sending the correct data. I have verified the correct operation of Z_UpdateStageTable stored procedure and the Instead of Insert trigger. Removing the Instead of Insert trigger doesn't have any affect. The After Insert, ...

Is there a way to explicitly specify a u/p using windows authentication for ms sql?

Is there a way to explicitly specify a user/domain/password when using windows authentication for MS SQL? I mean in the connection string. Edit: I would like to connect to another SQL server with a specific username and password on a different computer so impersonating I don't think is possible. ...

Index Seek with Bookmark Lookup Only Option for SQL Query?

I am working on optimizing a SQL query that goes against a very wide table in a legacy system. I am not able to narrow the table at this point for various reasons. My query is running slowly because it does an Index Seek on an Index I've created, and then uses a Bookmark Lookup to find the additional columns it needs that do not exist ...

Is there a good way to create a recurring import for an ASP.NET site?

The site I'm working on is running Windows Server 2003 and SQL Server 8 (2000?), and ASP.NET 3.5. I need to have some sort of script or application run to import data from an FTP'd text file, into the database. There is already a site running on the machine, that uses the current database. Can I use a scheduled task to reliably kick o...

What are your naming conventions for SQL Server objects?

There are seemingly a lot of very diversive naming convention recommendations for sql server objects. I was wondering if there are some formal guidelines other than not prefixing stored procedures with sp_ ? As pointed out by Matt, there is already a similar question: http://stackoverflow.com/questions/7662/database-table-and-column-n...

Connecting to an mssql server from a remote machine gives Login failed for user ''

I get this error when I try to connect to a remote SQL server using this connection string. Error: ODBC error: 28000118452[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ''. The user is not associated with a trusted SQL Server connection. Connection string: "DRIVER={SQL Server};SERVER=testserver,...

Should sql server schemas be used for logical or administrative grouping?

Is it agood idea to divide my SQL Server objects into schemas based on their logical grouping (a kind of namespace s.a. sales, user, common) or should they be primarily used to create different security boundries? ...

How can I have multiple common table expressions in a single SELECT statement?

I am in the process of simplifying a complicated select statement, so thought I would use common table expressions. Declaring a single cte works fine. WITH cte1 AS ( SELECT * from cdr.Location ) select * from cte1 Is it possible to declare and use more than one cte in the same SELECT? ie this sql gives an error WITH cte1 a...

SQL Server 2005 DB Mirroring Error

I'm getting the following error when trying to setup SQL Server 2005 DB Mirroring on my servers. I am running two Win2K3 servers with SQL 2005 on each with one of those running alongside a SQL 2000 Version. After restoring the database with NORecovery and configuring the endpoints, I run into the following error when I try to start the...