• Automate TSQL Query Output

    I want to have a stored procedure run on a schedule that automatically creates a database output file as a result and saves it to a specific location on my network. Can someone please tell me how to do this?

    Eabouzeid175 pointsBadges:
  • Import data file into SQL database

    I need to import tis .dat file into sql database table having four column client-007092~WITCO clname-CORPORATION ,matter-0005,mattername-LAZY OIL V. WITCO

    Anamika8315 pointsBadges:
  • Virtualizing SQL

    Is it possible to run SQL Server 2000 on a VM on a workstation? If so, anything special to consider?

    greg08115 pointsBadges:
  • How to find who called a stored procedure

    I would like to know what process or stored procedure called one of my stored procedures. Is there any way of getting this information from SQL Server 2005? Thanks in advance, Ed

    Olivera15 pointsBadges:
  • Sql Server CAL

    I have a Sql Server Enterprise 2005 64X, installed licesed by processor, I what to cut budget so thougt if I change to CAL licensing could save money, but know how to calculate how many users are currently conecting to my server. How can I get this info?

    Noyo775 pointsBadges:
  • SQL 2005 Database Compare

    If there a way to compare two similar database to find where a Stored Procedure is different between the second database. Different in it not there or the Create Date or Modify Date is different?

    SQLNovice15 pointsBadges:
  • Subquery only returns column names

    I have the query below, but when I run it, I can only get column names to return. Can someone please help me??? For each subject there are multiple values at each marker. I want an average, by date, for each subject at each marker. I have spent literally hours on this... Thanks in advance for any...

    Docmom12315 pointsBadges:
  • SQL Syntax Error SQL0104

    I have to recreate a duplicate logical file, but I can't use the crtdupobj command because it doesn't recreate the correct library pointers. Using the dspfd command. I'm attempting to recreate the logical file in a different environment(library). Using the exact same commands (different library)...

    DLM2007280 pointsBadges:
  • File access restriction for users in Logmein

    Hi, Please let me know whether logmein has a feature to restrict access of certain type of files for users. For example we have sql database having customer,account details etc.We need to restrict user who connects remotely to not to access account related files.

    Knw5 pointsBadges:
  • SQL Server schema

    Hi,    How can i get the user names assigned to the Schema through (T-SQL) Regards; Rino

    Fhhdjfhjdhfjhjdfh135 pointsBadges:
  • change track in sql server 2008

    HI, use Northwind Alter database [db_track] set change_tracking=on (change_retention=3 days,Auto_cleanup=on) i m running the above  command i m geting the ERROR AS Msg 5011, Level 14, State 5, Line 3 User does not have permission to alter database 'db_track', the database does not exist, or the...

    Fhhdjfhjdhfjhjdfh135 pointsBadges:
  • anybody can tell me that how to create setup which will accept database name & server name

    anybody can tell me that how to create setup which will accept database name & server name trhough which i can create database in perticular server during setting up the application. i mean to say i don want create manually in sql Server, which should be created during sepup only

    Vshikarpursan5 pointsBadges:
  • password recovery of win 2003 server…..

    Hi, I disjointed my server from the domain and I forgot the local administrator password of this server!!!!now I don't have the access to the server!!! I downloaded some free password recovery tools from internet but they are demo version!!! Could you please help me!!??? Thank you. ----- Regards...

    Aliyani265 pointsBadges:
  • Data Warehouse Query Performance

    We have a data warehouse with summary and detail level data with Cognos as the reporting tool.  If we have data for 100 large customers loaded in the fact tables and are trying to use Cognos Query Studio.  Here is the scenario:  one user has access to data for 5 customers through the security...

    Florida7775 pointsBadges:
  • Which tool is best in all aspects?

    Which tool is best in all aspects - speed, performance, user friendly, to do all activities etc - PL/SQL Developer or SQL Developer or TOAD

    RajeshITK65 pointsBadges:
  • What is SQL Azure?

    Sorry for this dummy question, what is SQL Azure?

    ITKE56,530 pointsBadges:
  • help me create trigger update column

    CREATE  TRIGGER Trigger_UPDATE_BIENLAI_TIENNOP ON BIENLAI FOR UPDATE,INSERT,DELETE AS IF (@@ROWCOUNT = 0) BEGIN PRINT ' TABLE is null' RETURN END IF UPDATE(TIENNOP) BEGIN UPDATE BL1 SET BL1.TIENNOP = BL3.TIENNOP FROM BIENLAI BL1,DELETED BL2,INSERTED BL3  WHERE BL1.SOBL = BL2.SOBL AND (BL3.TIENNOP...

    2110805 pointsBadges:
  • Would using a table variable from a function be efficient?

    We divided our tables from table zone_a, ..._b, ..._c to zone_z, these tables have the same attributes. We have divided this tables in this way so that any data that is under zone_a would only be on it's specific table, and the same with the other remaining table. Since per table holds thousands of...

    C114020 pointsBadges:
  • About MCTS 70-432 Certification

    Hi Sir, I got to know whether i should get the training from any of the study center for the certification or will it do if i continue with the selfbased training and then appear for the certification .Is the certification that difficult that i have to join a regular training session ,as m on with...

    Fhhdjfhjdhfjhjdfh135 pointsBadges:
  • Consistency errors on virtualized SQL 2000 SP4 servers

    Did anyone experience problems with SQL Server 2000 SP4 and consistency errors on o 2003 R2 x64 guest OS. CHECKDB shows databases corrupt, the next run they are clean, then they might become corrupt again. We are banging our heads against the wall to find a solution for this problem. We have this...

    ITKE56,530 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