SQL Server

Page 3632




  • Topics
    Replies
    Last post
  • Add column with fixed number of values (text) to the select statement
    by Suzej
    6 Replies
    Last post by Suzej
      • Hello, I have such a problem. Need to add additional column to my query. The column should consist of set of fixed number (same as number of query rows) values (text). At start thought it's simple but now Im lost. Is there any chance to do it. Apreciate any help. I need to tell that I have only access to select on this database so no use of operation on tables.
  • SQL 2005 - Migration from SQL2000 / LEFT OUTER JOIN
    by Sascha05
    14 Replies
    Last post by Tom Phillips
      • Hi! I have to migrate an Application from SQL2000 on a SBS2000 to a SQL2005 on a SBS2003-Server (german version) (SP2 for SQL2005, all patches installed) I made an backup of the SQL2000-database and imported in SQL 2005. Everything looks fine, but some things are look quite weird: The application runs following SQL-Statement against the Server: (I verified this with the SQLpro
  • Editing Input Data in Script Component
    by ronemac
    14 Replies
    Last post by jwelch
      • This is very similar to the post: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1901076&SiteID=1 I am trying to do this. Basically, if the field I am checking contains a space - not an empty string - I want to assign it an empty string so it will get converted to NULL when it hits the SQL destination. The space character from the source is causing the rows to fail I want to for
  • SQL Server Management Studio Express won't open but appears in task-bar
    by Chris Gunn
    1 Replies
    Last post by Buck Woody
      • When I first installed SQL Server Management Studio Express everything worked great The next day, when I try to open SQL Server Management Studio Express I get the Startup Screen then all that happens is SQL Server Management Studio Express appears in the taskbar but no window appears I think my problem has something to do with a SQL related product crashing one time when I shut do
  • Pass parameter to SSIS
    by Steve Jensen
    3 Replies
    Last post by Steve Jensen
      • I have a SSIS package that imports (appends) data to a SQL table from an ODBC source. This package is run from within a VS project. I'd like to pass a parameter to this package to limit the records it imports. I have seen some discussion of this but I need a detailed step-by-step or a good working example. Specifically: 1. How to get the parameter to the package to begin with. The VB functio
  • SQL Server 2005 Express Edition
    by mike98631
    1 Replies
    Last post by Arnie Rowland
      • Is SQL Server 2005 Express Edition, compatable with Visual Basic 2008 Express Edition
  • Upgrading SQL Express: is it possible to restrict to which version upgrade is possible?
    by Harald Hedlund
    3 Replies
    Last post by Jens K. Suessmeyer
      • Greetings, I am about to let users upgrade their SQL Express installations to Standard Edition. They will all run the upgrade program by a command line argument that I will supply along with a setup.ini that I will supply. Is it possible by simple means "hack" the setup.ini file in order to only allow upgrade to x86 Standard Edition We have DVDs with all kinds of editions for both
  • Partitioned Tables and Parameters
    by SQLDataMonkey
    10 Replies
    Last post by SQLDataMonkey
      • Hello all, I was wondering if anyone else ran into this and if how you got around it. In a nut shell the SQL optimizer it NOT pruning the additional partitions from the execution plan as would be expected when applying a constraint directly against the partitioned table¡¯s partition key, Instead its scanning every partition that you have set up in you partition function range.. Yet when you
  • Granting Permissions using SQL 2005 Schema...
    by Justin Conger
    4 Replies
    Last post by Justin Conger
      • All, I have been asked to grant a Windows group Full access to all tables under our Sandbox Schema. This will allow these users to do anything to the tables under this Schema. I created the Windows Group (Sandbox Users), created the login in SQL, created the user in the database that is tied to the Windows group, then ran GRANT CONTROL ON SCHEMA::[Sandbox] TO [Sandbox Users].
  • replication folder's didn't locate local publications,need help!
    by pinkybaby
    10 Replies
    Last post by pinkybaby
      • Hi, i'm doing POS system by using C# in visual studio 2005. Recently, i installed the microsoft sql server management studio on my pc, i plan to do merge replication through local publications between my pocket pc and my pc. So, i opened the replication file which is under Object Explorer in microsoft sql server management studio, it ONLY show me the local subscription folder under the replication
  • Returning a value that has the smallest number of instances in a table
    by NeilAtTawanda
    4 Replies
    Last post by richbrownesq
      • Hi Please help! I'm really stuck. I have a table (AssessorAllocations) that stores the data of students who have submitted assessments for marking by an Assessor. Each time an assessment is submitted by a student my program must determine which Assessor has the smallest workload and then assign the current assessment to that Assessor. My problem is how do I determine which Assessor has the
  • Error Casting String to Date
    by huskerwendy
    10 Replies
    Last post by huskerwendy
      • I have a Foreach loop container that I'm using to loop through a directory and copy files to a new directory. The file name contains the date and I need to compare the value to the current date to determine if the file should moved. I'm having a problem converting the string to a date. I have a FileName variable of type string that is in this form: 200710221200_FileName_7001.log I have a FileDate
  • Reporting Services Matrix Reports Repeating row labels
    by Marty Levine
    0 Replies
    Last post by Marty Levine
      • Is it possible to repeat the row labels for matrix reports where there are multiple groups. So if the matrix report rows are department,division,employee then have all three labels show up on each row not just at the breaks. Cannot seem to find a way to do this. thanks
  • COUNT and COUNT_BIG are too slowly, what to do?!
    by sseerraajj
    2 Replies
    Last post by Marcel van der Holst - MSFT
      • hello.. I used COUNT_BIG to get the number of rows but it was too slowly. I have 100,000 rows in the table. select COUNT_BIG (*) from topicstbl where partID like '" & PagePartID & "' the first execute for this query taked 5 secondes. and in another times it taked 1 second. this mean when the rows count will be 1 million it will take 10 secondes or more! what I
  • LDAP vs ADSI parameter problem Part III
    by PedroCGD
    2 Replies
    Last post by PedroCGD
      • Dear friends, In LDAP query inside SQL Server, How can I return more than 1000 rows It's a limitation in this type of queries... Someone know to return more than 1000 rows Thanks!
  • Column Name
    by Lovericky
    2 Replies
    Last post by Madhu K Nair
      • How to get column names and column data types of a particular table using T-SQl
  • SERVER MESSAGES to textbox
    by diego75TO
    3 Replies
    Last post by Jens K. Suessmeyer
      • HI! i need to grab the "server message" from sql server when i execute a sql script. i would retrive all messages , 'print' output too in order to put the messages into a textbox. is this possible and how
  • What is the easy way to do this?.
    by Visio User
    6 Replies
    Last post by Chris Howarth
      • My table structure... enddt datetime(8) status varchar(20) when enddt time equal to server time. I want to change status field to expired. What is the easy way to do this . enddt status 8/22/2005 7:00:00 PM expired 9/22/2005 8:30:00 PM expired 10/30/2005 7:30:00 PM live 11/22/2005 9:30:00 PM live
  • SQL Server 2005 Log Shipping Error 14262
    by JonathanMX
    3 Replies
    Last post by Mark Scurrell - MSFT
      • I am getting the following error " The specified servername does not exist " when I run the Log Shipping procedure. There is only a Primary server running Win Server 2003 withe Service pack 2 and SQL Server 2005 with service pack 2 and one secondary server runnung Win Server 2003 R2 with service pack 2 and SQL Server 2005 with service pack 2. All permission setting look ok . Can anyone h
  • Is it possible to know whether report is still executing in report viewer? (Web Forms)
    by The Akash Jain
    2 Replies
    Last post by The Akash Jain
      • Hi All, I have a Report Viewer and a Exit button in Web Form. Untill the report is processed i don't want to enable the button. so Is it possible to know whether report is still executing in report viewer I am using Remote Mode. Any help will be appreciated. Thanks Akash
  • Help using copy database wizard
    by BCandy
    4 Replies
    Last post by Faiz Farazi
      • I am trying to copy a database from one sql server 2005 to another. I am a sysadmin on both servers. I first tried copying the same database on the same server using the wizard and it worked :). However when I tried copying it to a different server, Execute SQL Server Agent Job fails. Unfortunately, I don't know the exact error; the error message ought to have been logged to windows event log, how
  • SQL2005 [264] An attempt was made to send an email when no email session has been established.
    by Chaseman
    11 Replies
    Last post by Merrill Groat
      • [264] An attempt was made to send an email when no email session has been established. The message is from a job which will send email to an operator when it is completed. In the operator notification setting, I'm sure the correct email address has been input for the 'Email Name' text box, such as abc@xyz.com SQL Server 2005 Std Ed, Windows 2000 SP4. However the Database Mail is configure
  • Variable Array like implementation using T-SQL
    by Mapuia Zote
    3 Replies
    Last post by Manivannan.D.Sekaran
      • Hi, I want to perform Oracle's VARRAY like implementation in SQL SERVER. How should I go about it I've done an implementation in Oracle where I have a VARRAY variable which stores a number of insert statements where each INSERT statement is a single array element. I then traverse through the VARRAY and executed each INSERT statements inside a loop.
  • SSAS Client - OWC ? Anything else ?
    by Soori
    6 Replies
    Last post by dork
      • Hi, I've setup SSAS 2005 environment and Cubes etc..I want to develop OLAP client in ASP.Net (to view cube based reports) over web. Will OWC is the right choice We don't want to use any third party controls or packages and want to go with microsoft suite. If OWC is the right choice where I should start with Any guidance / help on this is much appreciated. Thanks !
  • Existence of a value in table
    by mohanbabud
    4 Replies
    Last post by AKuz
      • Hi, I have a table with the follwing values Table Cats { CatID, date ----------------------- Cat1, D1 Cat2, D2 Cat3, D3 } I just wanted to check whether Cat1 exists in the table. Can anyone post the query Thanks ~MOhan