Answer Questions

• happymozart I am a complete novice to SQL Server 2005, and I desperately need help!

  Hi, I am looking for good documentation and examples to use to 'study' for Microsoft exam 70-431. This has everything to do with nuts-and-bolts Database Administration of SQL Server 2005. The December BOL examples, do not cover enough topics. The topics that are covered are not in enough detail. The 70-431 exam requirements are very detailed. This seems to be a nuts-and-bolts test. I am looking for nuts-and-bolts study material. No books are published yet. Does anyone have any good ideas on where to find 'good' samples and tutorials meant for a person who is studying for the new Microsoft SQL Server 2005 Database Administrator Exam MCTS 70-431 All answers and ideas in 'any form' are appreciated. Thank you very much. ...Show All

• averge joe Stored Procedure - Insert with table name from parameter

  First of all hi for all, I m trying to make insert stored procedure with parameters, i want to send table name and insert values with parameters, i m trying that below stored procedure but it gives syntax eror to me what shoul i do to correct it set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo] . [insertalepform] -- Add the parameters for the stored procedure here @type nvarchar ( 15 ), @talepbrmno int , @birimisteksayi bigint , @birimistektarih datetime , @aciklama nvarchar ( 50 ), @onay int , @seviye int , @talepformno bigint , @taleptarih datetime AS BEGIN SET NOCOUNT ON ; exec ( 'INSERT INTO [BelediyeWork].[dbo].[' + @type + 'TalepForm ...Show All

• GavinMannion Run a task multiple times

  I have a situation where I run the same taks multiple times during the execution. I would like to have one task which runs every time, instead of duplicating the task over and over 14 times in my script. Basically, it is an audit log, which I set variables and then insert into a SQL table the variables. I would like to do this: Task1 ------Success-----> Set Vars -----Success--> Log | Task2 ------Success-----> Set Vars -----Success-| (do the Log task again) | Task3 -------Success-----> Set Vars -----Success-| (do the Log task again) | etc This works, however, I have to duplicate Log over and over and over. No OR does not work, because it still only executes the Log task once. Another option I thought of, but cannot find a w ...Show All

• wuhuashouce Property DefaultSchema is not available for Database [DatabaseName]

  We're using Windows Authentication with our SQL Server.  We've added a domain group to the SQL Server groups and would like to give it a default schema.  The properties window is the same for users and groups but the default schema field is enable only for user entities.  We cannot add a default schema to a group.   Is this by design,  a bug or a problem with our SQL Server installation Updated on 2005/08/29 My first try was done at through Database\Security\Users.  I tried going through Server\Security\Logins and I got this error message    Alter failed for User 'Domain\Group'. (Microsoft.SqlServer.SMO)   Additional Information:   --> An exception occured while ...Show All

• GTrz Timeout and Audit Logout and sp_reset_connection?

  Hello, We've been getting some intermittent timeouts from our live website (the timeouts normally, but not always, occur when getting the user details - but that could be just because that task is happening the most often). However the strange thing is that this happens intermittently - but often enough to be annoying! I started a trace to see what was happening. I thought maybe it was a transaction/ or some sort of blocking SQL statement - however I'm not seeing anything that clearly indicates this.(I suppose the timeouts would only occur when another SQL was blocking the same db object, right And I don't think the updating of the user details are performed regularly.) However I did find some oddities that could maybe help: When we receiv ...Show All

• minigendo Execute Process Task and IExplore

  Hey I have a problem with the Execute Process Task.in the Control Flow. When I use the Execure Process Task to start IE (internet explorer) to execute a webpage (an .asp page) the task allways fails. What should I do to avoid a failure. I can work around the problem and getting to the next Control by using on Completion instead of on Success, but I will prefer to have the possibility to do some error handling (like sending a mail to me ) should the task realy fail. Suggestions and ideas are welcome. Peter ...Show All

• VS2005_evaluator When Windows Firewall is ON, SQL Server does not get connected thru TCP

  I am using SQL Server 2005 Express + SP1 on a Windows Small Business Server(SBS) box. The SBS is connected to a client thru LAN. Following are what I gave as IP address and DNS on the server: IP: 192.168.16.2, subnet mask : 255.255.255.0, Preferred DNS server: 192.168.16.2, Default gateway and Alternate DNS Server blank On the client, I have, IP: 192.168.16.4, subnet mask : 255.255.255.0, Preferred DNS server, Default gateway and Alternate DNS Server blank I can ping and connect to either of the machines. If I do a sqlcmd -S "tcp:servername\INSTANCE,port", I get the following error message: HResult 0x80090304, Level 16, State 1 SQL Network Interfaces: The Local Security Authority canno ...Show All

• fighter92 Slow Cube Performance in Excel

  Hi all, I have an Analysis Services 2005 cube that I am linking to in Excel 2003 via a pivot table. The cube is based on a single fact table with around 6 million rows and 7 measures. I have 5 dimensions, none of which have more than around 200 rows. I have set up aggregation and am using MOLAP. My problem is that querying the cube in Excel takes around one minute, whilst performing the same query in the cube browser in BI studio is instant. I have captured the MDX for each of these in Profiler. The scripts are below. BI Studio SELECT NON EMPTY [{59956A97-57AB-4CAF-8A5B-E7753FDA221C}Pivot16Axis0Set0] DIMENSION PROPERTIES MEMBER_NAME, PARENT_UNIQUE_NAME ON COLUMNS, NON EMPTY [{59956A97-57AB-4CAF-8A5B-E7753FDA221C}Pivot16Axis ...Show All

• Asday SQLException - How can I get the query that caused it?

  Using ADO.Net and SQL 2005, we have an exception handler in one of our .VB classes. We extract all the information from the exception and dump the stack into an email, but we would also like to see the query that caused the exception. Is there an easy way to get the offending query without putting a try-catch around the hundreds of queries Thanks. The query is not included in the stack. What could help is that if you already use a centralized access model where the query is executed from one single class to put there a try/catch around it, getting the actual commandtext and throwing it back as additional exception data. if you are not using any centralized model you will probably need to implement ...Show All

• manqueInspiration How to copy a DB, with T-SQL?

  Good afternoon. How, with T-SQL, to copy a database under other name (i.e. the DB - bd1 should be copied it in bd2. Business occurs on one server MS SQL 2005) But to copy, so that transferred all procedures, triggers, ... . Thanks! And how it to make by means of Microsoft.SqlServer.Management.Smo. in C# .Net 2.0 backup database bd1 to disk = 'c:\bd1.bak' go restore database bd2 from disk = 'c:\bd1.bak' move '<data filename>' to 'c:\somenewfolder\bd2.mdf' , move '<log filename>' to 'c:\somenewfolder\bd2.ldf' go ...Show All

• awj100 Check the finish time of data driven subscription using Sql

  How can I check using sql that a data driven subscription has run and the time it had finished Thanks Elias Hello Elias, Run this from the server with the Reporting Services database: select c . name , el . TimeStart , el . TimeEnd , el . TimeDataRetrieval , el . TimeProcessing , el . TimeRendering from ReportServer.dbo.executionlog el inner join ReportServer.dbo. catalog c on el . reportid = c . itemid where c . name = 'ReportName' order by timestart desc Hope this helps. Jarret Try this: select c . name , el . TimeStart , el . TimeEnd , el . TimeDataRetrieval , el . TimeProcessing , el . TimeRendering ...Show All

• Mike Hildner fill up spaces with dots in a column

  Hi, I currently have a column in a table with data type char and length 500. However, not every column fills up the entire 500 length, and I would like to fill up the rest of the spaces with dots. Is there a setting in SQL to do this I do not want to use varchar since I want a fixed length with dots at the end. Any ideas Thanks, Alan I can't really imagine why you would have that requirement, it is kinda backwards. If your goal is to display the data padded with dots up to a total length of 500, then I'd suggest that you do use a varchar for storage of your data (without dots). When you want to retrieve it, then you pad it. Something like this; create table #x (mystring varchar(50) not null) inse ...Show All

• Ron J51027 Microsoft-phobic

  I and my team have built a state-of-the-art web app using SQL Server 2005, Analysis Services, Reporting Services / Report Builder and Notification Services. Cool stuff! I have a prospective customer who for unknown reasons does not regard Microsoft and its technologies as first-class; they prefer Oracle / Java. Can anyone suggest a reading list White papers, independent comparative analyses, etc. Thanks to everyone in advance. Brian Brian - This happens more often than you might think. After a technology comparison (If you're looking for someone other than Microsoft with this info, you can find some here: http://www.mssqlcity.com/Articles/Compare/sql_server_vs_oracle.htm ) , it all comes ...Show All

• Chinwa KneeHo SQL SMO Object

  hi all, i'am engaged in migrating the database of one application which is developed in VB6.0 and SQL Server2000 to SQL server2005. Here the client is using the SQL DMO objects of SQL2000 to perform many database data manipulations for the end user, my problem is when i'am connecting the application to SQL2005 that session is ending up with an error. From the compatibility documentations i come to know that we need to use SQL SMO objects instead of SQL DMO , when i checked in msdn online i could only find code to connect to vb.net, can any one provide me information how to use SQL SMO object in VB 6.0..... thanks in advance Mat pls log your issue on http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID= ...Show All

• imdqa mapping

  hi! i have two different databases (SQL 2005 and Oracle) and i need to map their tables with one another. how will i do this thanks ahm, I'm just new at using oracle and i'm a little bit confused.. could you please explain a little more thanks! However, I found that in order to get it to work, I needed to use brackets around each element such as the following: SELECT * FROM [LINKEDSERVERNAME]..[DATABASENAME].[TABLENAME]. I wouldn't have found it out had I not used the "Script table as..." command by right-clicking the table in the Object Explorer! This wasn't mentioned in BOL. Brian J. Matuschak Actu ...Show All