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 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...

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...

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 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 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,

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...

Is there any way to tell Crystal Reports to return null instead of an error when it encounters division by zero?

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...

Hi,

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

Thanks,

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...

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...

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...

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...

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?

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...

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.
...

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...

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...

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...

What is default password for Windows SBS 2011 SQL

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

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...

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.

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...

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...

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...

Hi,

I'm using SQL 2008 and I'm wondering how can I execute another query if the second query in the UNION statement doesn't return any results.  So the total number of queries executed will always be 2.

I have this code:

 

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...

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...

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 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....

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...

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...

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...

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.

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?

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'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 -...

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:...

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?

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...

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 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.

...

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?

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 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 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}) +
 " " +...

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...

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.

We are looking to hire a SQL DBA as those of us on staff managing SQL don't have the time to further our SQL understanding with all the other responsibilities we have. We have a growing number of SQL servers. Can anyone list a few of the key...

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 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...

 

Thanks

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...

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'...

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

In MS SQL server, the Logins are created automatically after I create a user in the ERP application - in my case it is MS Dynamics GP.

The default database for the logins is System.

Now If I need to import the database into a newly created...

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...

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...

When moving SQL Server 2008 server (Windows 2008 x64 ) to a virtual environment(VMWare vSphere 4.11), we have CPU and memory issues: (Current VM: 1CPU, 4GB Ram)

1. When running a large query with no other users, it takes 10 minutes, the CPU...

Hello,

How can I detect mssqlresource db because there isn't in the table sys.databases?

Thanks

bibi

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...