• Being notified when a delete operation is performed on SQL Server

    How can I be notified of delete operations in SQL Server? Is there a tool out there (or something) that will notify me when a user performs a delete operation, without the user knowing about this activity?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL server as data source for OBI EE

    hi everyone,i have been using OBI EE for the past 2 months.I have been using Oracle 10g database as a data source for OBI EE and it worked just fine and now im trying to use SQL server 2005 as my data source. My ODBC was succesful and i can import from that database but i get following errors when...

    NewIT5 pointsBadges:
  • Formating Sysmessage text

    How does SQl Server generate this error message What happens when an error occurs in a User defined Stored Procedure. Which System stored procedure is fired I know that the error messages are stored in "sysmessages" table in "Master" Database - but which system stored procedure calls this table...

    Teguma15 pointsBadges:
  • Allocated Memory Alert

    Our clients newly installed SBS 2003 R2 is sending out Allocated Memory Alerts. My co-worker says this is common for SBS installations, something to do with SQL Server. He figures we should maybe shut down the SQL service, as it is not in use at this company. I have certainly seen this crop up on...

    AndreaF7,570 pointsBadges:
  • Changing date fields in SQL Server Analysis Services

    In SQL Server Analysis Services, can I change the date fields from (yyyy-mm-dd) to (dd-mm-yyyy) without turning the date field into varchar?

    SQL Server Ask the Experts2,585 pointsBadges:
  • order of evaluation in DateAdd with multiple expressions

    I've spent 3 hours researching how order of evaluation would work in this expression. If @BeginTime was 16:45:00 for example, what would be the result of this expression? set @BeginTime = DateAdd(mi,-Datepart(mi,@BeginTime)-Datepart(hh,@BeginTime)*60,@BeginTime )

    LHalkape15 pointsBadges:
  • Error connecting to a SQL database

    I receive the following errors when I attempt to connect to a SQL Server database on my home computer: 1) Keyword not supported: 'intigreted security'? 2) An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Why isn’t my data displaying in the next page of Gridview?

    I added a sqldatasource from my toolbox to my aspx page. I then configured the sqldatasource to connect to a table. I then added a gridview to the same aspx page and selected the sqldatasource as it's data source. In addition to other column formatting etc., I set paging to true. I then opened the...

    Ilfoprog50 pointsBadges:
  • Sql Query in AS400

    I am trying to execute a Query String but I receive following error Query exceeded the specified time limit or storage limit however my query length is normal, nevertheless i have executed larger query too. How to solve this problem.

    Mr. SEA130 pointsBadges:
  • Crystal Reports in vb.net

    iam getting error while making connetion to sql server by OLEDB provider. The error is Sql server does not exit or access is denied ,sqlstate 08001

    Shaz255 pointsBadges:
  • SQL server 2005 to SQL server 2008

    I am following using sql server 2008 but following some lessons written by BOB Taybor. Is MyCompany.mdf for 2005 abailable in 2008 format?

    Standaman15 pointsBadges:
  • windows Server 2003

    Hi, we are in the process of developing an SQL Server-based application for the purposes of monitoring historical server performance and baseline data. Which windows Server 2003 tool and specific data-gathering option would be best suited to obtaining this information?

    Jessie12320 pointsBadges:
  • Free Chapter – Beginning Spatial with SQL Server 2008

    Another free chapter download is available on the IT Bookworm Blog. Written by: Alastair Aitchison Book: Beginning Spatial with SQL Server 2008 Overview: "Microsoft SQL Server 2008 introduces new geography and geometry spatial datatypes that enable the storage of structured data describing the...

    BrentSheets6,875 pointsBadges:
  • SQL Server error: Cannot find log file

    I am receiving the error, "cannot find log file." I detach the database and I am unable to reattach it because of the error. I created a new database and copied the MDF. When I restarted the SQL Server, I am told the database is suspect. What can I do to fix this error?

    SQL Server Ask the Experts2,585 pointsBadges:
  • sql in C#

    How can I attach And detach a database file to sqlserver in C# code ? please give me an example of this

    Sajjadzare5 pointsBadges:
  • Restoring a deleted table in SQL Server 2005

    How do I restore a deleted table in SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Variables in T-SQL

    Hi, I want to know y does the following script run in SQL and not in T-SQL DECLARE @tblName varchar(30) SET @tblName = CONVERT(VARCHAR(20),GETDATE(),112) + 'Table' DECLARE @sql nvarchar(4000) SELECT @sql = 'CREATE TABLE "' + @tblName + '" ( ID VARCHAR(15), Name VARCHAR(15) )' EXEC(@sql) go it gives...

    Babar198220 pointsBadges:
  • SAP Implementation

    Has SAP been iimplemented in Shipping Company? Who are the implementation partners. Is SAP ecc 6.0 ideal on oracle DB or SQL DB.?

    Enjay15 pointsBadges:
  • search Button In vb.net 2005

    The code is for searching entire sql database if i enter RegistrationNo which is primary key plz help.iam getting errors. If IsNull(TextBox1) Then MsgBox "Please Enter the RegistrationNo" End If If IsNull(Me.TextBox1) = False Then Me.Recordset.FindFirst "RegistrationNo= '" & Me.TextBox1.Text & "'"...

    Shaz255 pointsBadges:
  • Field in crystal reports duplicating lines from quote

    Using Crystal Reports XI on windows XP accessing SQL 2000 running on windows 2003 server using a Visual Manufacturing database. This is hard to describe accurately but here goes... I am running a report that uses QUOTE, QUOTE_LINE, QUOTE_PRICE and QUOTE_Binary_to_notes. QUOTE_Binary_to_notes is a...

    Mcgentrix5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following