Hot Solutions

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

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

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

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 always submit my method="post" forms to the same asp page.  How would I do it to a separate asp page?

Thanks...

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,

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?

Hi,

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

Thanks,

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

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

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

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

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

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

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

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

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

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

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

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

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

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 permission is required to log into SSIS and deploy packages in MSDB?  Thanks.

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

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

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

What is default password for Windows SBS 2011 SQL

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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

I have read over almost everything that I can find but I am not able to solve this problem (yet).  It is probably simple and fundamental and I am overlooking it.  I am using Eclipse (Indigo) and microsoft JDBC 4.0 .  I unzipped this into a folder...

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

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

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

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

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

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

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

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

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

 


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

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

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

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

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

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

Getting errors in Failover cluster manager,
also shows resource online (Name resolution Not yet Available)

Here are some events, need help fixing issue


Log Name:      System
Source:        Microsoft-Windows-FailoverClustering
Date:    ...

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

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 want to update the FullDescription field based on a value in the Name field :

SELECT Name
FROM  Nop_Product
WHERE (Name LIKE '%(MEN)%')    :

ACQUA DI PARMA by Acqua di Parma (MEN) COLOGNE SPRAY 3.4 OZ

FullDescription field :
...

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

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

Probably an elementary question. Does Active Directory require a SQL Server? We have SQL Server running on our backup domain controller and I'd like to remove it to free up the license. Thanks in advance!

Hi Experts,

We have a query that works well for one day, but... we need the data produced from the query for the past 4 years. This is a once off query, so performance is not an issue.

I am looking for a way to use a loop to run a query:
-...

Hello,

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

Thanks

bibi

I am trying to install SQL express server 2008 R2 on windows xp but getting error message saying Acess denied?

Hi Experts,

I have menu name names stored in a SQL server table. I need to fetch this menus, loop through them and disable on the main form. I have been unable to to do so. Please assist.