Hot Solutions

My question is how to get my system to a state to reinstall VS 2010 .
Recently I installed the beta version of VS 11 along side VS 2010 and SQl server 2012(yes i had 2012 sql server running and working prior to installation of VS 11) after using...

Hi All,

I got the following error when I tried to change the DB owner from "sa" into the custom user that I want that is "ip"

 

How to make it happens please ?

any step by step guide would be great.

Thanks

HI
I have some problem with retore operation with my snap manager for sql
the backup operation completed successfully
When i trying to restore the from some backup i get the folowing error:

[16:12:01.182]  Retrieving ONTAP virtual disks...

I have a system running Windows Server 2008 R2 64-bit.  I need to connect it to a database server that is running Interactive SQL Version 9.0.2 via an ODBC connection.  I cant figure out how to install the ODBC drivers on my 2008 R2 server.  Any...

Hi Experts!

My apology for question not being  clear, as any perfectly formulated question by itself shows an answer.

Im designing database in SQL Server. Not taking into consideration all other Entities, I have two. One entity is...

I have an ssis package with a For Each Loop that loops through a variable that was populated by a recordset destination from a SQL table.. The variable contains image names.. Inside the loop is a file system task that copies each one of those...

Hi Experts,

How experts, I need to create a pagebreak based on a pagebreak parameter in SSRS 2008R2.

If the the parameter returns a  1 =  pagebreak and if it returns 0 no page break. Would would be the best way to accomplish this task and...

I always submit my method="post" forms to the same asp page.  How would I do it to a separate asp page?

Thanks...

Hi,

I have the above error in VCenter 5. Found a KB but this is about VirtualCenter 2.5 and vCenter Server 4.x  whereas I used VCenter 5 and installed it with SQL which it installs automatically.


J.

I need to read this XML from a SQL table - what's the best way of doing this?

I don't have a table definition to populate at the moment so some indication on how to read different nodes and levels in the XML would be good.  So far I have tried...

Hi,

I need to select only numeric values from the column which has varchar

ex:

i have two columns

name varchar(10),
ident varchar(10)

i have values like this in both the tables

name                   ident
-------------      ...

Hi Everyone,
I have a question on loading data from an IXF file into a DB table(s).
The IXF is a backup from one DB and contains several years worth of data from a source. I want to load only the "new" records to the target, ones where a...

Hi experts,

Mental block!

I need to list the first name and surnames of all those in an SQL table who have the same surname.  

Any help appreciated.

Thanks

Col

Hi Experts,

I want to create a Continued on the next page  message in my ssrs report, however of course it should not appear on the first or last page, how do I write an expression to accomplish that?  I place the code below in a textbox (in...

How do I underline part of a concatenated expression in ssrs?

Hello Experts,

I have stuck on a this little issue...i cant seem to import a date field YYYYMMDD from flat file Soucre to a SQL DB. I am using SSIS 2008.

I get the below error message:

SIS Error Code...

How can I limit the number of rows returned based a date parameter?  I's like to filter my dataset if the date selected is a Saturday.  This is my SQL:

SELECT DATE,TIME FROM tblAPPOINTMENTS WHERE (DATE = @DATE).  In the table, there are...

Hi Experts, I have been given an assignment of taking a list of addresses and determining the lat/lon for them.  I'm at a bit of a loss as to how this can be accomplished.  I did see a previously entered note here which did the job in HTML for a...

Hello Experts,

I need a logic for one of my application, where I have two tables ITEMS and . I need to get an Avg. value of the Items.

Sample Data:

ITEMS
----------
ITEM Prev_COST Curr_Cost  
101        $12                    $15
101...

Good Morning experts,

I have a MSSQL database that is populated compleatly in all caps but I want to pull some of that data to be used in a crystal report to generate letters to be mailed to customers.  I need to be able to change the data...

Hi,

do you know if TFS 2010 work against SQL SERVER 2012?

Thanks,

I have a varchar(max) field in my SQL Server database table.  My field has RTF characters that I need to strip out so that I can display the text only.

My SQL Server 2008 is on a windows 2003 server.

I created the function below which I got...

Hi experts

I plan to use Sata SSD in HP server in Raid1 for a ts server and a MS db server.
Do you know if there any compatibility issues with third party SSD (ex, intel,kingston..)
with those servers.
I know there's HP ssd but those are...

Hi

I want to put together a visio digram representing my ssispackages....ideally i want use vision shapes that are similar to Control flow items in SSIS...

Thanks

Q. How do I insert data into newly created database tables having relational constraints to one another?

Is it possible for 2 servers to share a SQL 2008 R2 database located on a SAN for transactional purposes.  The  servers will have separate internet connections (origins of the transactions) and there is no chance of conflicting transactions...

We have a MSAccess 2000 compatible database running in MSAccess 2007.  A table in Sql Server 2008 R2 is linked via odbc.  This table has a bigint field as the primary key and in MSAccess we only see #deleted in every column, every row.

The...

I have a data table that is set up like this

ID           DateTime                          Data  Inc1  Inc2  Inc3  Inc4  Inc5  Inc6  
354        3/15/2012 8:00 AM          150    25     10        5       15    10      20

all Data is setup...

Experts!

Please help on me on understanding the pros and cons of having File-maker as UI and MS SQL in the backend for data storage.


The problems I see is with table links and joins in SQL wont work as well?

We already have MS SQL...

Hi expert Team,

I'm using this SQL query to load data from myDatafile.txt to my Database using bulk insert with file format like below:
 

i have a problem which cause a headache for me and appreciate your help. Everything is working fine...

We had an issue where our SQL 2008 Express server rebooted and for some reason it's no longer listening on tcp 1433.
It has changed to 53300
Can someone tell me how I can change it back to 1433?

thanks

I need some help with a query that I can't quite figure out. I am trying to get a DISTINCT list of CODES with a NAME given that the NAME has multiple values.

I don't care what NAME it uses just that it gets one but the CODE should be unique.
...

So here is our company's setup... We have 2 locations...main location and a colocation at our data center.  At the Data center we have multiple sql servers (2005 and 2008 R2).  We are trying to connect via Management Studio to the 2008 R2 sql...

SSIS Script Task.

I am using a ForEach Container to get the file as a variable (User::foundFiles).   I am using it in a previously built DataFlow Task so I know it works just fine for that.

Within this Script it's throwing an error saying...

Hi team,
I am learning how to create file groups, partition functions, partitions schemes, partition tables, and of course, examine around 100K records and play around with the performance and enhancements and hopefully learn something today. So...

Hi Experts

This statement is from a Crystal Report, What would bethe SSRS version?


if isNull({VW_RPT_PREINVOICE.CUSTOMER_PO}) then {VW_RPT_PREINVOICE.KEYREFERENCE}
else if isNull({VW_RPT_PREINVOICE.KEYREFERENCE}) then...

What is default password for Windows SBS 2011 SQL

What permission is required to log into SSIS and deploy packages in MSDB?  Thanks.

we are trying this

UPDATE table1
SET description = REPLACE([description], '''', '') where username ='user123'

error:

Argument data type text is invalid for argument 1 of replace function.

How do you calculate RunningValue with (ReportItems!Textbox56.value) type of values.

The calculations are in decimal values and (ReportItems!Textbox56.value) calculation is  = IIF((((Fields!UNITBIDAMOUNT.Value) <> 0 or...

We have set a cross data center mirroring,we frequently getting an alert stating ,mirroring session timed out for 90 seconds.(we have set this value).
But after 3 to 4 minutes, it resume the connection.how to troubleshoot this issue?

By...

I have a SQL Server database (2000-2008) that is used as a back-end to a VB.Net 2005 Windows application. It currently uses varchar and text data types that will need converted to unicode. I understand the nvarchar and ntext part of this...

I am trying to pull in some information from our database and am having troubles pulling the addresses in due to the formatting of the tables and am looking for suggestions on the best way to pull the information in.

Here is what the table...

Below works, updating the value
to 2012-03-15 09:17:24.910

How can I change so it always
keeps the end as "02:00:00.000" ?

update [ReportServer].[dbo].[Schedule]
--set [StartDate] = '2012-03-30' + substring([StartDate],11,13)
set...

We have an ancient database that uses a strange system of listing ingredients for products.  Each product code can have up to 20 ingredients, but each of those ingredients has it's own field in the table.  So insead of having a field for...

Hi there,
I have a column data type Float and what i need is to convert to whole number without doing round, floor or none of that. Just to make my point clear lets say i have  7.50 what i need to do is the number to looks like this 000750 and...

If I use following test-code

SELECT     Sym, Verfall, Aktiv
FROM         tblWbi
WHERE     (Verfall < GETDATE() - 7) AND (Aktiv = 1)

I get following results

Sym                                                Verfall                     ...

I need simply the COUNT of the following statement:

SELECT       t1.UserID, t1.State, t1.City, t2.Active
FROM          City AS t1 INNER JOIN
                      members AS t2 ON t1.UserID = t2.UserID
WHERE     (t1.State = 'New York') AND...

I am planning to hire a freelance form designer in livecycle to create a series of forms for me.

These forms need to be interactive with a SQL server database.  

Does the designer need to have SQL experience or is that something I can work...

Hi

I have a table that stores a year and month age e.g. 8:4 (8 years and 4 months old) in two columns e.g.

8:4        9:11

I would like to be able to select on this table so I can select rows that fall into a range which I supply e.g....

In my ssis pack I need to convert excel spreadsheet from SharePoint to Pipe Delimited data file, not comma delimited( because couple fields has “,” within). In Execute Process Task  I use PowerShell script that create  .csv file but I don’t know...

Looking for just  rough / general recommendation on the amount of RAM that should be given to a VMGuestOS thats running SQL 2008 R2 on Windows 2008 R2.

Some considerations:

A maximum of 60 to 80 people would be connected to it at any given...

Hello Experts,

I am having trouble creating a query that will summarize data from a few tables that store sent fax history... Here's the basic query:

SELECT *
FROM documents doc
JOIN history hist ON hist.id = doc.docid
JOIN...

Hello and thank you for taking a moment. I am trying to build a  table by looping through the contents of an existing table.  Once built I try to select from the newly created table (@BPRLIKELISTRESULTS)  but sql server gives the following error:...

Greetings,
I have two tables.
Table A:
Col1 PK
Col2 Fld1
Col3 Fld2

Table B:
Col1 PK
Col2 FK
Col3 Data
Col4 TypCd <--this is a typ code related to data (cause of my headache ;) )

I have Select PK, Fld1, Fld2 from A;
I want to...

I host a www company website. This Windows web server, which is www accessible, needs to access a corporate database located within a VPN via telnet port 23. How do I access this database from my public server?

In VB6 how do I create and encrypted password and store it in an initialization file for my program to decrypt and use for opening a database.

Hi,

I'm trying to build an SSIS BIDS project that was developed by a different user but keep getting this error when trying to build the project.

Error      1      System.UnauthorizedAccessException: Access to the path...

I just installed MS SQL 2008 R2, and I'm trying to create accounts for other users to access and administer SQL Server.  How can I do this within SSMS?  

I've seen instructions that mention something about right-clicking on a mythical...

I'm trying to migrate some queries over to SQL from Access.  I'm having trouble replicating the following in SQL:

Relist: DateDiff("d",Now(),DateAdd("d",31,[Uploaded_date]))

Any ideas?

I'm trying to grab employee hours for the current fiscal year.  What I want to do is take today's date, since the user will be interested in the current fiscal year, and if its before May 1st then the pay period BETWEEN would be May 1, 2011 -...

I'm trying to set up a linked server within a sql server 2008 r2 express database.
The user for sql service it's not the default one, i'm using, sqlsrv (created within user domain group).
The linked server is created but every query returns...

Hello,

After running this command and seeing this error in the systems logs and SQL Server logs, I see this error.

Command:

DBCC CHECKDB (wss_pbc_content_hermes) WITH ALL_ERRORMSGS, NO_INFOMSGS

Error:

Msg 824, Level 24, State 2,...

Hi,

I reached the database limit for Sharepoint foundation 2010 and now I cannot delete or create any file. I cannot even empty the recycle bin. Does anyone have ant pointers on how can I increase the database size? If that is not possible,...

i have a query select storename,productdescription,quantity,(quantity * averagecos) as totalcost,DATEDIFF(day,datereceived,getdate()) as day from accessoriesstock

but i am looking for an out put like
storename,descritption quantity under...

Is it possible to push GIS data from a Microsoft SQL Server Database to a Postgre SQL Database?  If so how? Is it a one-to-one database connection or do you need to run some sort of script?

I have two columns in a SQL Server table (LATITUDE and LONGITUDE).  They are of data type nvarchar and are look like this:

LATITUDE "3608.914 N"
LONGITUDE "7747.16 W"


I can convert LATITUDE and LONGITUDE to type float using the following...

Hi,

Please advise what is wrong with the statement below -

 

I'm getting -

Msg 157, Level 15, State 1, Line 3
An aggregate may not appear in the set list of an UPDATE statement.

As my error -

Thanks

I have a application that give me the following error when I try to launch a page that retrieves data from sql express server.
This app was developed in vwd and runs but i moved it to iis so it can be run ass an app on the local machine.

...

Hi Experts

I need to convert this from crystal to SSRS... What would this expression be in SSRS

if {VW_RPT_PREINVOICE.USEMATERIALDESCR} = 0 then
(totext({VW_RPT_PREINVOICE.LENGTH}) + " " +  ucase({VW_RPT_PREINVOICE.INVOICEDON}) +
 " " +...

OK all, this is truly boggling to a few experienced people in my reach as well as myself. All of a sudden my Exchange server 2010 stopped receiving emails. I can send out just fine except from my SQL server receipt email to customers. I have done...

When I run the act reader utility the password is autofilled,  but when I try to reset the password so I can get act data in to crystalreports... it says the password is incorrect.

update #reddytemptable1 set datereceived = MAX(t2.datereceived) from #reddytemptable1 t0 inner join
arjayiqm.arjaytelecom.dbo.iQclerk_Transfers t1 on t0.storeid = t1.storeidto
inner join arjayiqm.arjaytelecom.dbo.iQclerk_TransfersAndProducts t2...

Should an initial ERD be in 3rd Normal Form. Or should the normalistion happen latter?

 


I am trying to change a font color on a line that if the date is more than 60 days older than the current date, it would show up in red, else it should show up in black.

The above expression seems like it should work, but it isn't.  Any...

Hi There,

I'd like to pull out records where the day of the week is Friday or Saturday. So I have the following query:

 

I get an error message thus:

Microsoft OLE DB Provider for SQL Server error '80040e14'

An expression of...

I've linked our iSeries to our SQL server.  I've created a view with this:

Create View View_name as
 
SELECT *
 FROM [10.1.1.253].[S10778CE].[AIR400].[AGENT]

Where would I find this view?

Hi Gents,

I have a very simple question to which unfortunately I cannot see the answer

I have the following querry:

  SELECT DISTINCT a.[PROGRAM_NAME]
  FROM [GF_MAINT].[dbo].LOGIN_PANELVIEW AS c
  inner join...

Hi expert, i created and extenal data to access another database in sql, and every thign is working fine, but when i reu the list to get the data i am getting the following error
"external data invalid credentials"
note that i have full...

Hi

I have created a slowly changing dimension on a contract table. I scheduled it last night and check it this morning. It seems to have appended the rows i though it would only update those that have changed. For example last night on initial...

Hi

I have a crystal report whose data source contains a field of type nvarchar(max) . I want to use this field as a dynamic data patameter for the report.

The - Create Parameter - dialog box doesnt list this field in the available fields'...

Hi
My questions relates to the best practices approach on maintaining and doing housekeeping to keep tempdb size in check.
I have a 237GB SQL Server 2008 Data Warehouse Database and buisness users use Microstrategy to create/run reports...

Using SSIS I need to connect into exchange folders for a number of network users to copy their emails and all attachments.  I need to download emails (with attachments) from an exchange server as *.msg files to a local folder using SSIS.

I'm new with SQL Azure, is that means this only availabe as cloud service from Microsoft ?

What are the scenarios in which a Database should preferably be made in Oracle as opposed to Sql Server?
In other words are there any limitations in Sql Server in terms of performance, Functionality, etc that are better addressed in Oracle?

I having a problem converting a varchar field to date.  The challenge is the field can have variable date in it.  

Example  10/19/11
                12/7/11

If I concatenate 20 before the date so it reads 10/19/2011, I am able to use

...

I have a complex xml file that I am parsing to load into db tables.  I have attached one of the xml files for viewing.  I am currently working on the FuelLine data. I want to number the fuelLine for each one in a //SaleEvent.  So the first...

I need a solution to take a file from the ftp server and process it to upload it into an MS SQL db table.  I have a rather clunky way of doing this now through several different apps and schedulers.  

What is the preferred way to handle this...

I'm trying to create a report that will display all the employees, their sum(hours/pay) per week (user selected), their sum(hours/pay) per year (current fiscal year), and break down their hours/pay for the week into details (ie date, service...

Hi
I have to import a CSV file containing several million rows into SQL Server, in which one specific column contains a comma in some records. This comma is causing the import to split the field value into two pieces and move values into the...

Hi,
Can anyone here provide some directions as to how to change the default SSRS url http://servername/ReportServer/Pages/ReportViewer.aspx?%2fNewDKR%2fDKR1  to some other name like http://mynewurl ?  
I am using sql server 2008
thanks

Hi there,

When I open SQL Server Configuration Manager I get an error, see attached .jpg image. This happens even though I am signed-on as Administrator and when I launch it as Administrator. I am running SQL Server 2008 R2 on Windows 7...

1. I am extracting a zip file in a folder. I want to read all the extracted file names from that folder in a script task (string[] file_names = Directory.GetFiles(@"c:\MyDir\", "*.pdf");)).
2. Now, I want to write the array file_names in an...

Microsoft Office 2010 using an .adp file to connect to a SQL Server 2008 R2.

When trying to make modifications (increasing column size, setting/removing PK's/identity) we randomly come across the following error:


ADO error: Incorrect...

The database was backed up on a server running version 10.50.1600. That version is incompatible with this server, which is running version 10.00.1600. Either restore the database on a server that supports the backup, or use a backup that is...

OK, so I'm pretty new to C# development, and I have an issue that I am just not understanding.

I have a SQL Server 2005 compatible DB with a series of tables. The ones that matter are the Users, Compatibility, and Suppliers tables. There is...

I am trying to pull out some data from a MySQL DB where the values in 2 columns need to be replaced with values from another table during runtime.  
To be more specific, i'm trying to select the schedule for a bunch of teams and then display it...

I am currently using sql server 2000 to create a cross tab report. I need to convert it iinto sql 2008.

I have 3 tables
Location table: ID, Locationname
Defect table: ID, Defect Name, date added
DefectFeedback table: ID, LocationID,...