Programming SQL
in [Microsoft SQL Server]
|
Working Now... Ok its working now. Initially I was copying the DLL out to the Development Server and executing T-SQL script to Create Assembly from DLL and the Functions from the Assembly. When doing this I received no errors, except that it would error when attempt was made to execute a function. I deployed the SQL Server... 13 Sep 2006 09:58
Grouping sysjobhistory I'm trying to report on the runtimes of a couple new jobs through several iterations, testing various code and data changes in each iteration. The sysjobs and sysjobhistory tables have all the info I need for this, except I'd like to add a column showing the run iteration for each job. I'm surprised this isn't al... 5 Sep 2006 19:04
Reading .LDF i understand the third party tools, and even using profiler in certain instances, but for myself I need to track the user activities of the db, per login/user and all the info is in those ldf files. I need to extrapolate the info for reports for the boss. I cant use log explorer in our app, although I wonder if i can... 31 Aug 2006 18:46
Bulk Insert from Excel I´m new to this subject. As a matter of a fact, the first time I´m trying this. I need to run a BULK INSERT query where the datasource is an Excel file and the destination is a table in SQL 2000 Server. After looking at the Books on Line, I´ve tried first: BULK INSERT Database.dbo.Table_tbl FROM 'c:\files\F... 31 Jul 2006 05:29
The context connection is already in use (SQLCLR) Hi, I have created a CLR Strored Procedure. When I call the Stored Proc I get below error. Msg 6522, Level 16, State 1, Procedure GetPhaseStatus, Line 0 A .NET Framework error occurred during execution of user defined routine or aggregate 'GetPhaseStatus': System.InvalidOperationException: The context... 14 Jun 2006 12:14
HELP! "could not complete cursor operation because the set options have changed since the cursor was declared" I am declaring a dynamic generated cursor in a nvarchar string and passing it to sp_executesql. I then want to open it and loop over the results using FETCH INTO. This worked fine in SQL 2000. In SQL 2005 I get the error message that I put in the header. It thinks that the SET OPTIONS have changed between m... 19 May 2006 17:02
Msg 226, Level 16, State 6, Line 4 ALTER DATABASE statement not allowed within multi-statement transaction. Hi, I am trying to execute a simple statemnt that I got right out of books online and I keep getting this error and I cant figure out what Im doing wrong: ALTER DATABASE [00057088] SET SINGLE_USER WITH ROLLBACK IMMEDIATE Msg 226, Level 16, State 6, Line 4 ALTER DATABASE statement not a... 21 Apr 2006 15:15
SQL2005 Import I am attempting to import the contents of an MS Excel spreadsheet into a new table in a SQL 2005 database. However, I keep getting the following error... Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Source - TellerUse$" (1) ....This is not the first time I've rec'd that e... 6 Apr 2006 01:18
NOLOCK SQL Query Safety Hi, I have a question that has to do with the safety of a NOLOCK SQL Query. The situation includes a database that is hit very heavily by a workflow engine. I have a request to build a app that will query the same tables as the workflow engine and generate reports. I am worried about the reporting applica... 24 Feb 2006 14:21 |