Answer Questions

• JD Li How do I get the script to create a table & all the Indexes

  In SS2K I could go to task and it would script the table, indexes and any other script that was set for that table. How do I do it with 2005 Thanks No. How do you use it Thanks Have you looked at the Generate Script Wizard You might want to check out this tool:   http://www.sqlteam.com/publish/scriptio/   -- Adam Machanic Pro SQL Server 2005, available now http://www..apr ...Show All

• lc247 SQL query

  I have the following table and I'm trying to identify sessionid's where the group of category name(s) in one searchcriteriaid group differ from another searchcriteriaid group, in the same session. In the example below the user searched in the same session (5575628) twice (searchcriteriaid 60658874 & 6068961) and used the same 2 category criteria (Land, Multifamily), therefore, I’m not interested in identifying these. But, in the last sessi ...Show All

• Reinsouled URL Access using Impersonation

  I need to display a report by impersonating a specific user (to test I have hardcoded a user and pw.  I have modified the web.config as follows and gave the  user browser rights in report server. < identity impersonate = "true" userName ="mydomain\myusrname" password ="mypw"/> I have created an asp.net page with the following code behind a button to display the report.  Dim impersonationContext As System ...Show All

• Sijmen VS2005 --> sqlExpress via the IDE

  hiya, When I try to add an sqlExpress connection via VS2005 the "serverName" dropdown displays "machineName"..I select my machineName and test the connection. It won't connect.It doesn't connect when i try "machineName/SQLEXPRESS" either. It DOES connect when I use ".\sqlexpress" Why, in the "serverName" dropdown , does it display invalid server names Is this a bug Maybe I need to ...Show All

• Shane Dixon Cannot change default server port 1433 on SQL Server 2005

  Hello, On SQL Server 2005 Dev Ed I have disabled all protocols except TCP IP. With Sql Server Configuration manager, I have set the server port to 1450 (in sql server 2005 network configuration) and the client port to 1450 (in Sql Native Client configuration). The result is that I cannot connect anymore to my local server. I get the following error: Cannot connect to ... Additional information : ...TCP provider, error 0 - no connecti ...Show All

• Mablao New Guy Question 2: SQL on-the-fly at package runtime?

  Here I go again...thanks for your patience... I'm trying to create a single, all-purpose SSIS package that would move data from a source database table to a matching target database table. The requirement is to create the package such that the SQL statement used by SSIS could be supplied at runtime. This would allow a single package to be used for different SQL statements, representing different tables, rows and columns, etc. as needed. The data ...Show All

• Alexan Dose sqlserver 2000 support Array type?

  Any one know about it Can't you just use a table with one column as an array You could create a table variable in this way that would act like an array, maybe add an identity column which would be your index, and the second column would be your data column. This is not an array, but can be used like one, for example you could iterate through it with a cursor or a while loop. You can use this function I po ...Show All

• Anil S Making SQL Server 2005 reachable from the Internet

  Hello! I've got SQL Server 2005 Standard Edition Community Technology Preview and I'm wondering how can reach it from the internet The thing is that I've got a laptop that I want to be able to connect to the SQL Server that is on my stational computer at home. Since I want to be able to work on the same data both at home and on my laptop when I'm not home, I need to be able to reach it from the internet. Thanks in advance! Martin Lundberg S ...Show All

• Healer Help! Can I control the recursion times of a recursive CTE?

  I have a table describing a hierarchy structure and the number of levels is very large, say 10000. Can I control the recursive CTE to get the first 1000 levels Thanks! Yeah, it goes on the query, not the CTE (kind of wierd syntax, but anyhow) WITH Employee_CTE(EmployeeID, ManagerID, level) AS ( SELECT EmployeeID, ManagerID, 1 AS level FROM HumanResources.Employee as Employee UNION ALL SELECT ...Show All

• jamil GUID

  Hello, I'm working on a smart client app that has an offline sql express store and needs to work with several types of central databases (support for multiple products - ms sql, DB2 etc) While trying to put together some offline functionality that needs the user to create records on the offline sql express data store, we've run into the need of being able to uniquely identify records so replicating the data in the offline store back into t ...Show All

• msnath Dialog security with different instances of a service

  I am in the process of evaluating the use of Service broker for messaging in a load balanced configuration, and am not having any success.  My configuration is as follows.   1) Master database on Box #1 which is the initiator of all dialogs 2) Target database on Box #2 3) Target database on Box #3   One of my goals is that the databases on Box #2 and #3 are as close to identical as possible.   My ...Show All

• burstingfist Transaction log shipping over WAN with compression

  Hi guys, I have a server in a datacenter (SQL 2005 ent) that collects large quantities of data from our visitors. I need to set up a secondary database in our office (different geographic location) that will server 2 purposes, 1, a backup of the database and 2, allow us to perform complex queries on the data. There is no updating of the data on the secondary server so no changes need to go back to the primary server. A database in standby ...Show All

• Why_did_I_go_64-bit? Upgrade SQL Server 2K to SP4

  One of our windows service logged following events Event Type: Error Event Source: MSSQLSERVER Event Category: (2) Event ID: 17055 Date: 1/31/2006 Time: 7:56:04 AM User: N/A Computer: blah blah Description: 17066 : SQL Server Assertion: File: <rowset.cpp>, line=3260 Failed Assertion = 'm_cILockBytesOpen == 0' ================================================================== Event Type: Error Event Source: MSSQLSERVER Event Catego ...Show All

• pbriggsiberia IF statement Errors in huge SQL Query

  I've not gotten the If statement to work. Before: http://www.webfound.net/sqlbefore.txt After (with IF statement): http://www.webfound.net/sqlafter.txt I don't want to include the deletedpdcs if the month is today in my SUM for PDCs_IL basically is what I'm trying to accomplish here are you referencing the correcdt files I don't see a single IF statement anywhere. And if you're ever getting any errors, you need to post the error he ...Show All

• DieterP Data as points in chart??

  Hi, I have created a chart report with 3 - D cylindrical bars. The chart basicallys shows 7 different kind of costs for different procedures of a hospital. I need to show some benchmark data on the same report in form of a line. However, in 3-D, the line looks very odd as it appears very thick in 3 D mode. I also tried with minimum thickness but it didnt work well. Is it possible to show the benchmark data as just points on the chart Tha ...Show All