I'm an absolute newbie to Microsoft SQL Server 2005, and I'm trying to work my way through the Analysis Services Tutorial. I've got as far as "Reviewing Cube and Dimension Properties" in Lesso...
How to cCopy stored procedure between SQL Server 2005 databases
I created a simple SSIS package that takes data from a database using a query and dumping it to an excel file. I've added 2 "Excecute SQL Tasks" to the Control flow task. One to create the t...
Hello. I currently have a stored procedure in SQL Server that returns a correlated set of lab test results. It pulls the needed data from a few different locations combining the results into a...
I have 2 databases. Let's call them DB1 and DB2. I have created a view, call it vDB1Table, in DB2.
I have granted my user, DummyUser, permission to Execute/Select from the view vDB1Table....
I have a stored procedure that does a search on a customer table. I display the result set in a Gridview on an ASP.net page. If no where clause is set the query could return 50k+ records. The ...
I am dynamically generating an insert query. i.e. at run-time, I will come to know which table is going to be used and which fields of the table are going to be used in the query. I want to ex...
Does anyone know how to dump data from an MS SQL database with pre-made insert statements without hand coding for each table?
I know about querying INFORMATION_SCHEMA.COLUMNS etc but don't ...
Hi,
Would appreciate if someone would provide the difference between using the data type varbinay(Max) and storing the files in the file system using vs2005 and SQL 2005.
I am already fa...
I am looking for an sql function that will give me first/last day of the current and next month...
as an example I am looking for something like this
select custName, CustomerNumber, Fir...
Hello,
i have a quite general questions:
We have some performance issues with our SQL 2005 Server and are looking for possible causes.
Here some details about our Test Setup ( we've g...
I have a stored procedure which has a few parameters.
One of the parameters is @Check
I need to decode a value returned from a function
fn_CheckValid which takes in a string of an order n...
I have attached a code snippet that creates the database and user that I am using to connect. My question is that since Portuguese (Brazil) regional settings use the format for currency value...
I have an automatic update for SQL Server 2005 that fails to install. I tried downloading it manually from Microsoft and installing but received the following error:
Product ...
Hello,
One of my SQL 2000 database's transaction log file is taking up most of the drive space and I want to create a second log file on another drive of the server.
I am looking for the bes...
Hi,
I am working in integration services SSIS. I have the following issue: I have to write an SSIS job which can be scheduled to run at a specific time.
It needs to run these two q...
I have a Clustered MS SQL 2005 server that has a database that was migrated several years ago.
Made a lot of record changes in the database today and our log file grew to 3.8 GB. So I was ...
I am trying to create a custom installation package that won't take my end users very many steps. Currently there are 4 - (1) Install .dot net (which I am not worried about because most of ...
Hi,
I need to read 1,000,000 rows of data from a SQL table and have been using the ExecuteReader function which has proved to be much too slow. Could someone please advise on the best, (e.g...
Can someone tell me what the purpose of the following function might be: I came across it in an older stored proc. Really what I am wondering is the effect of the "1440" - it seems its just r...
What is the best way to copy data from one table in a BD to another table in other DB.
the tables are not the same tables, so I will need to specify where the data from the source will go in ...
The identity specification of one of my primary key columns on an existing table is set to No. I want to set it to yes and add an Identity Seed to it. When I go to the table properties it wont...
I'm trying to do entry validation in a DataGridView. I created a sub using the CellValidating event to test the data and that works great. IF the data is bogus, I can cancel the event using ...
Hi,
I would like to use the replace function to achieve the following..
String to be searched is 'Japan 2008'
It is possible Japan to be one of US, China, Fiji and UK (e.g. UK 2008)
...
Hi, I have a Stored Proc that gives me All Active Employees for any given date range. I have a function that I need to include in the Stored Proc for user security. I need to enter the user na...
