I'm running a SQL 2005 Server which will have 90+ databases. What is the best way to run automated backups? I would like to archive them locally on another disk and also on the network.
I have a .NET application that uses an access DB for information storage. We have upsized the access DB to SQL 2005, and need to re-engineer the application to connect to the new DB/server. ...
Microsoft Excel: How can I convert a column of numbers into one row of numbers separated by commas. I need this to put in a SQL Query formula!
The actual file is attached.
For example. ...
I'm looking at documenting a database of stored procedures.....
I'm interested in any tools in existence that any of you might have found useful in the past.
I just installed a SQL Server 2005 in Windws XP SP2, but I an't understand how I use SQL commands like create tables and so on. I must be an interface program or browser to execute these comma...
Greetings:
I have the query below named:
SCFN_GetAssetTypeLoc
The guts of this function look like this when I hard code the parameter:
DECLARE @Result VARCHAR(1024), @Code VARCHAR...
is it possible to create encrypted backups (.BAK) files in SQL 2005?
I have a backup of a sql 2000 database. Can I restore that in sql 2005?
if not, how can I transfer the data from sql2000 to 2005?
I'm attempting to do an in-place upgrade of MSDE SP4 with SQL Server 2005 Express SP2. I have two instances of MSDE on my computer, but I'm only upgrading one of those, which shouldn't be a p...
Create Procedure SP_CheckCountOfQuestions
@outCount int output
as
if exists( select sequencevalue from sequencelist_new where columnnm='Question')
Begin
@outCou...
Hello Experts,
I have a stored procedure that inserts the return value of another stored procedure into the column of a table. It looks like this:
@DateLast smalldat...
Hi I have following select command (see Attached Code Snippet ) and I am having following error :
Msg 8120, Level 16, State 1, Line 1
Column 'Zakladne_informacie_GroupOne.Id' is invalid in t...
I am developing a website and associated database with MS Visual Web Developer 2008 Express and SQL Server Mgt Studio Express. I have deployed my site and database to my web host's server. I n...
Hello there Experts,
I'm trying to build a report for comparing sales of current month vs previous month. The report should look like the following:
Brand Sales_Last_Month Sales_C...
Hi,
I have the following commands. I am getting an error while deleting from derived table. Can you please help ?
USE Sample
GO
-- Create a table
CREATE TABLE employee
(
...
Is there anyway on a SQL report to set the focus onto a parameter field??
I have 8 different steps in a process that I need to indicate as done or not in my VB.NET application.
I have a SP that queries my database for 8 different steps. If the step is completed ...
Is there any way of creating a view even if the tables/views it uses do not exist?
Oracle has the FORCE keyword, but I can't an equivalent in T-SQL.
Jim
okay here is some screen shots I have 2 different tables the keys are different names but the data in the fields have the same numbers
I have this sql statement below in the snippett box
I...
hi there ,
i have a table in sql 2005
the table contain this colums :
RunId CustNum Sunday Monday Tuesday Wednesday Thursday Friday Saturday Type Shour Ehour TotalHour Pre ...
Hello
I've been trying to get message from a SQL Job that runs (see screendump), but I simply can't get it listed.
The stored procedures:
exec sp_help_job
exec sp_help_jobhistory
exe...
I need the collation on a table to be the same as the rest of the other tables in my DB. I am trying to create a table that has a foreign key relationship to that table and I get a collation ...
Hi
i have read a a paper from microsoft about the diffrences between the sql server editions , and when the SQL SERver Express Edition comes the author say
"A version of SQL Server 2005 fo...
I am trying to bulk copy from an XML file containing demographic information. The XML structure is as follows (data removed). When I try and bulk copy, the process fails if a record has data...
I am about to purchase an application, which will be based on SQL server 2005 SQL queries. The data is sensitive, health care related data and therefore, requires high availability. Before I...
