-
- Passing multivalue in stored procedures
by kix_eytin
- 6 Replies
- Last post
by LightTrainMedia
- Hi guys,
I'm new in SSRS, Im having problems passing multivalue in stored procedures. Can someone help. please.
Thanks in advance.
-
- Usin Application Roles
by dpd
- 3 Replies
- Last post
by Arnie Rowland
- I want to test Application Roles security for our project, I guess it serves the purpose.
But the quesion I have is if a developer who can look at the application code know's the "Password" can he set the password from Query Analyser and get acess to the database.
Thanks!
-
- Transmission of compressed snapshots
by aero1
- 7 Replies
- Last post
by aero1
- I am using SQL2005 merge replication and have pull subscribers on a low bandwidth link
I am compressing the snapshot into an alternate folder. Files are not put into the default folder
When I start a synchronization, I would expect the cab file to be copied to the subscriber and then the files to be extracted locally at the subscriber in order to apply the snapshot
-
- SSIS flakey dealing with share names
by P R W
- 5 Replies
- Last post
by JayH
- I have found SSIS is showing some strange behaviour when dealing with share names for file connections.
I have been using Package configurations and file connections to pick up excel files are using the name of the Share as the path to the file location.
What is strange is that SSIS appears sometimes to successfully see the file and other times fails with the error "....does not exi
-
- Sanity check -- adding single field index for fulltext indexing
by Jeremy Grand
- 2 Replies
- Last post
by Jeremy Grand
- I'm getting ready to enable fti on sql 2k5. The tables I care about do not have single-field indexes, so I'm planning to add them. I've tested this in a limited way, and do not see any effects that would require changing the applications running against these tables, but I'd really like a sanity check on this. Is there something I should be looking at and haven't
The tables have primary ind
-
- Error authenticating proxy when attempting to run Job
by Breckar
- 7 Replies
- Last post
by Satya SKJ
- Hi, I am trying to get a maintenance plan on SERVER1 to backup to a UNC path on NAS1. NAS1 is managed by a 3rd party who gives us a username and password to connect to our directory on the NAS. I have created a matching username/pass on SERVER1 (WIN 2003 SP1). I can logon as that user and browse to the UNC path without being prompted for credentials. I can read, write, and delete files and directo
-
- Override a foreign key constraint
by Bank5
- 1 Replies
- Last post
by richbrownesq
- A website that I'm working on has users sign in and keeps a log of the pages they go to. The log table has a foreign key in it that links to the username is the users table. I need to update the username for one of the users but the foreign key is preventing me from doing so. What is the benefit of having a foreign key like this Can I delete it to update the username or is there a better way
-
- Manual Instal of AdventureWorksToGo database in mobile client software factory (mcsf)
by varisai
- 3 Replies
- Last post
by Mike Wachal - MSFT
- I want to manually install the database for the reference implementation (I have SQL 2005 Express when I installed the Factory, but AdventureWorksMobileStaging database is not installed in my sqlExpress, so i try to install manually in that database ) I have noticed a number of scripts under the AdventureWorksToGo\DBScripts folder. Is there any specific order of installing those scripts Any other
-
- insert problem with primary key
by Yongpil
- 10 Replies
- Last post
by IngJVV
- Hi there,
I wrote a script to copy data from server1(epxress) to server2(2005 standard)
SET identity_insert results on
GO
insert [server2].TEST.dbo . results
select * from [server1] .TEST . dbo . results
results table are identical with primary keys.
Problem is when run this code it gives an error
Msg 8101, Level 16, State 1, Line 1
An e
-
- Stored Procedures
by Tigers21
- 11 Replies
- Last post
by Tigers21
-
I heard about "Stored procedures" ...But I'm not sure when I should use it...It is only when I will display information from the database or could it be used even when saving to the database
I have the following code (which save a value from a textbox in database)...How do I convert this code so it use stored procedures instead...(if its possible to use
-
- Permissions with Windows groups and view to other databases
by sdi_rob
- 3 Replies
- Last post
by Raul Garcia - MS
- I am having a problem with permissions using Windows groups. I have a database (database1) that has permissions granted via Windows groups. Two groups (group1 and group2) are members of the db_datareader role in database1, and this work fine. Do to the number of tables that get created during our work, using db_datareader is the easiest way to keep up with permissions without creating a maintenanc
-
- SQL Express 2005 SP2 and Local Service account
by dave c
- 5 Replies
- Last post
by dave c
- I'm trying to do an unattended install of SQL Express 2005 SP2, and specify that the service runs under the Local Service account. Prior versions of SQL Express worked fine.
With SQL Express 2005 SP2, however, the install fails on XP Pro SP2. It *does* work on Winows 2003 Server.
Here's the command line I'm using:
SQLEXPR.EXE /QB ADDLOCAL=ALL INSTANCENAME=FOO SECURITYMODE=SQL
-
- Updating webshop datatbase
by Marc Cicero
- 4 Replies
- Last post
by oj
- Hello all,
I'm working on webshop database consisting of these tables: customers, customers_groups, products_groups, products For every customer (in customers) there is an entry in customers_groups. The price lists that are used for every customer are defined in the table products_groups. In products_groups the ids of customers_groups and products are used to assign a special price to every gro
-
- Selecting distinct rows, please help me with the statement
by Antonio Fernández
- 3 Replies
- Last post
by Arnie Rowland
- Hello,
I'm newbie at sql, Im trying to get results from a query getting the last state an issue is. This are my 2 tables:
Table 1 : issues
id_issue
name_issue
data_issue
Table 2: hist_issues
id_hist
id_issue (have relation with issues.id_issue 1-to-many)
state
who
date_time
Well, Im using hist for save all the states where the issue is (r
-
- How to do this Query ?
by thukralz
- 3 Replies
- Last post
by Louis Davidson
- Hello Everyone,
I have 2 sampel tables something like this :
Table : UserInfo
Email - PK
Name
Address
Table : UserRegistration
Email - FK
Course
Sample Data for UserInfo
harsimrat@........ , Harsimrat Thukral , Some Street
data for UserRegistration
harsimrat@....... , CS 101
harsimrat@.......,CS 201
harsimrat@........,,CS30
-
- Mirroring and Cross DB transactions
by Puvendran
- 1 Replies
- Last post
by Peter Byrne MSFT
- Hi,
I have the following scenario
1. 2 databases A & B which are both mirrored in high safety mode (manual failover)
2. The mirror of A & B are on a separate and remote site in relation to the Principal
3. Some of the application functions insert/update to database A&B as one transaction unit
My query is give the above scenario should I expect any DB incosist
-
- Quarterly vs Yearly MDX problem
by SSAS is Fun
- 0 Replies
- Last post
by SSAS is Fun
- Mosha , I do have a question though. I am trying to calculate Average Seperation Count. I have an MDX that works properly at the quarterly level when I run the query in MDX, but does not work properly in the cube as a calculated metric. It is almost like I need to set the AggregateFunction on the calculated metric but I cant figure out how.
Here is the scenario:
My Mdx is:
Wit
-
- Dimensions renamed after AS2005 migration
by tomas_mbacz
- 2 Replies
- Last post
by tomas_mbacz
- We have just migrated a cube from AS2000 to AS2005 using the migration
wizard. As a result of this migration, some of the dimensions are now renamed
and under AS2005 we cannot rename them to the same name they had under AS2000
(the dimension names under AS2000 contained "." in them).
Exemple: "order date.YQMD" --> "order date YQMD"
We use Excel 2003 Pivo
-
- HOW-TO Change "text" column to "ntext" that is NOT NULL
by jaBowman
- 14 Replies
- Last post
by Arnie Rowland
- Hi All,
I have a table that has a column defined as:
[colname] [text] NOT NULL
and I want to change it to be
[colname] [ntext] NOT NULL
This table already has values in it (in this column).
I tried
ALTER TABLE [dbo][tablename] ALTER COLUMN [colname] [ntext] NOT NULL
But as the BOL describes I am not able to execute an ALTER COLUMN against a "
-
- get date field with the format mm-yyyy i.e. '02-2007'
by ajliaks
- 4 Replies
- Last post
by Louis Davidson
- Hi guys,
How should I do, in order to retrieve the date field "Table1.ValueDate" with the format mm-yyyy
Cast (Table1.ValueDate
Thanks in advance,
Aldo.
-
- copy data from a DB to a flat file using bcp
by shamen
- 9 Replies
- Last post
by shamen
- I'm trying to import some data from a data base table to a flat file. But I get a error message when I run BCP command in coomand line.
My bcp command is as follows.
C:\Documents and Settings\shamen>bcp databasename.tablename out -c-f flatfile.txt -T MSSQLSERVER
When I run this, I get " an error has occired when connecting to the server. This faillure may be caused by defa
-
- Example Databases
by johnkorz2006
- 1 Replies
- Last post
by Caddre
- Hello Everyone:
I am testing SQL Sever Express and I would like to know how to load the adventure works databaes into SQL server I have downloaded the files in accordance to the instructions providered however, when I open SQL Server the Adventure Works database does not appear. How do I add the adventure works database to my instance of SQL Server It appears that the files downloaded co
-
- how to add underline to "end" of expression text in textbox?
by crossitpro
- 8 Replies
- Last post
by crossitpro
- In SQL Reporting Services - How can you configure a textbox (in a table row/cell) to display (and more importantly print to hard copy) an underline area that is "appended" to the end of variable length text. The objective is to be able to print out a form with an identified area for handwritten text entry. I need the underlined area for the textbox to be "right aligned". For ex
-
- sql server 2000 database went into suspect mode why?
by jk555825
- 2 Replies
- Last post
by Madhu K Nair
- hi all,
one of my sql database went in suspect mode can any one advice why it has happened is it the problem with sql server . This has happend for the second time in 4 months .
thanks and regards
jk
-
- ALTER TABLE to Allow Null Values
by RLovelett
- 3 Replies
- Last post
by Arnie Rowland
- I have an (Access 2003) database and I'm trying to update the schema of the database to allow null values in a column. The column already exists and currently will not allow null values. This is a distributed application (everyone has their own different MDB file) so I need to be able to modify the column through T-SQL. My statement to try and do this is: ALTER TABLE clients ALTER COLUMN state VAR