Search results for query: *

I have a tsql stored procedure that contains print statements. I was wondering if there is a tsql command that I can include in the stored procedure that would disable/enable these output statements? Sometimes, I want to see the output like when I am developing in the procedure. However, I...

The following sql returns the following: "1E-07" How can I get the select @data to return the original value of '0.0000001' without the exponent being applied and displayed? DECLARE @data float SET @data = '0.0000001' select @data

I am working in an ms access environment with many tables and queries. It contains some linked tables and some access tables. The queries are built off of access tables, linked tables, and also other queries. I have vba code to loop through all query objects and display name, type, sql, etc...

Is there a way to use a like operator and both sides of the like equation are columns. Listed below are two examples of what I am thinking. Is there a way to achieve this logic in a standalone query, without having to write a script or procedure? select count(*) from table_a a where...

I am trying to execute an oracle pl/sql stored procedure from within sql server via tsql. I have used linked servers many times to perform selects and updates from sql server to and from oracle. I am looking for tsql syntax to call oracle procedure. Thank You.

I have an excel sheet that has 52 columns and 4000+ rows. The data in the sheet is raw data. I would like to add three rows at the bottom of my sheet to display max, min, and averages per each column of data. I know that I can click on the function button and manually build a single function...

I have a form built within fp that sends an email. If I access the page with an administrator account, then the form submits fine. If I access the page with a non-admin account then I get a login prompt. If I hit cancel the non-admin receives the following: You are not authorized to view this...

How can I change the owner of a maintenance plan?

Using Crystal 10.... I have a hyperlink value from a stored procedure. This field is formatted as a hyperlink in crystal using 'Current Website Field Value'. The hint states "This option will automatically create a hyperlink based on the data that is stored in the field in your data source."...

I have a Crystal 10 Report that is executing a ms sql 2000 stored procedure. I modified the stored procedure by adding an additional column. The column was appended as the field in the select clause of the returning sql statement. This new field is not showing up in my report. I have tried...

I am working with the sharepoint database. The docs table has a column titled MetaInfo. It is of type image. Its contents are xml files that store the metadata information about the doucment. I would like to create a procedure that queries this column and extracts the contants into a...

I would like to create a table in access via a sql ddl statement. The sql will be executed from a SQL Server DTS package. I have it working provided that I use varchar column types. The varchar matches to access's Text. But I am not sure how to specifiy an Access Yes/No data type for access...

In sql 2000, I would like to write my own restore script. I am using the dbmp to administer the database and transaction log backup dumps. What I would like is a script ready for on demand use, that will query the user or system database appropriate to obtain the last *.bak dump file and...

I have a sql 2005 instance. There are going to be multiple end users accessing a database on the server via windows authentication. I would like to restrict the access onto which objects they have visibility to. If I create odbc connections, by default the users see all the tables/views in...

I have built a maintenace plan that is quite basic and generic. It is set to execute against all database on the server. It covers the basic functions backup, integrity and optimizations. I set all my basic servers databases to simple model and do not worry about the transaction log backups...

I am getting ready to restore a 145 gig database. What are my best options for estimating the time it will take to complete the restore. This is a one time operation on a new server, so I do not have previous metrics to compare restore times against. I am aware of enterpise manager's restore...

I have several document libraries that use folders for organization and classification. The folders are located at the root level under the document library name. Within each folder are the many documents. I am now looking at creating views for this document library. I want the result set...

I am using log shipping via database maintence plans within SQL 2000 environment. The copy job and restore job are failing on my secondary server. The average size of the log shipped trn files is approximately 1 - 3 mb. Once a week, we rebuild the indexes and a 3 or 4 gig trn file will get...

I am getting the following error: error '80070008' Com Error Number :-2147024888--File Name :/email_CDO_remote_mail_server.asp--Error Line :5-- on line: Set ObjSendMail = CreateObject("CDO.Message") I have a fairly good knowledge of the cdo object and have used it multiple times. The asp...

I am trying query a tall table with sql and have the oupt appear as a flat result set for easier reporting. TALL table is what I have ------------------------- 1 a 2 b 3 a 4 a 5 c 6 d 7 e 8 f 9 g 10 a FLAT result set is what I desire --------------------------- 1 2 3 4 5 6 7 8 9 10 a...