• 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?

    ITKE345,295 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...

    ITKE345,295 pointsBadges:
  • sql server 2008 backup and restore

    can u get me the command to recover the database . my backup is in d:nor.bak . as i m running the command   >restore database 'd:nor.bak' it gives me the message as : Incorrect syntax near 'd:nor.bak'. pls let me know how to reatore . Regards, Rino

    Fhhdjfhjdhfjhjdfh135 pointsBadges:
  • how to save or export datareport from VB6 to PDF or JPG format ?

    i make aproject using VB6 & SQL server 2000 and the project has some report like bills , data , i want to save / export  the report to pdf file pr photo format to send it from the mail to another one who can not modify in my report the save or export shouldnot modify in the report format head ,...

    01067505895 pointsBadges:
  • SQLEVN70.RLL error

    IT Answer "Your SQL server installation is either corrupt or has been tampered with (Could not open SQLEVN70.RLL). <I have been getting this error during bootup since i tried to install the microsoft office professional 2007 trial software i received with a computer book that i am currently...

    Caspeak5 pointsBadges:
  • Can’t see step info in an existing job SQL Server

    I recently got a new computer and I had to installed sql server on it. When using my old computer I was able to log into my SQL Server and see/modify jobs, but now, even though I can see the list of jobs under my sql server agent, I cannot see any information related to the steps of that job. What...

    AgrKE5 pointsBadges:
  • SQL Server 2005 System Report

    I need some ideas of how to create a SQL Server System Report, i.e. how much memory has been consumed, how much time was taken in a job run? Can some one provide me an example, please? Thanx.

    RonitReno25 pointsBadges:
  • Are ITKE and MicrosoftExpert just shills for Microsoft?

    Is it just me, or are "ITKE" and "MicrosoftExpert" just using this forum to promote Microsoft SQL Server products? ITKE posts a leading question. MicrosoftExpert posts a reply (that reads suspiciously like Microsoft marketing bumf). ITKE marks the "solution" as "Approved". Is this an appropriate...

    Kccrosser3,830 pointsBadges:
  • Report Server Install Best Practices

    I am setting up my first Report server. Should the Data Engine and two databases that are automatically created reside on the Report Server or on another SQL Server machine?

    Mongo7305 pointsBadges:
  • How to Make Fixed Row Table

    Hi all My question is that i want to make the table which will accept only 500 row. even it could not accept 501th row. i mean to say i can't accept at the time of insertion not on fetch time

    DotnetDevoloper30 pointsBadges:
  • SSRS blank columns

    am having a problem with SSRS dropping columns from the datasource if the cell in the first row is blank. Is there a configuration setting that causes this? I don't want to crete a dummy first row that has something in every column in order for the reports to work. The data is coming in as an XML...

    Jamesczebiniak5 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