Just joined an IT group. All the SQL Server databases backup plans are that it is enough that the servers are being backup daily. Basically the mdf/ldf files have never been recreated as bac...
Hi Experts
Here is the scenario
I have created SSAS cube, at that point it asked me name of server (ip address) and provided sql authentication (to create new datasource), when I created the...
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.
How do i extend the timeout value
Hi,
This seems like a simple query I want to be able to loop through a list of user databases on my instance and do something such as detatch the DB.
for example: -
User databases: -
a...
Hi All,
I needed to add an additional database log file in order to do a reindex on a large database (1/2 TB). I inadvertantly put the file in the primary file group. I have emptied the fil...
Greetings:
I have a table that has two identicle columns. Somehow in the course of time an insert was made to the table so that I now have duplicates:
Key Field
-----...
Is it possible to use a variable that has been declared in the query for the path name in FOR XML PATH?
For example, I have a variable
@Section varchar(100)
How can I use this as the ...
Hi all,
i need to be able to dump an MS Sql database to a file (ie a backup) via code.
i've been looking for a command line version like mysql has (mysqldump) but haven't been able to find...
Hello friends.
I'm trying to create a CLR procedure that should return data combined from 2 tables called Pessoas and Documentos (Pessoas and Documentos stands for Persons and Documents).
Wh...
I receive this error message:
Msg 208, Level 16, State 1, Line 1
Invalid object name 'PBC.sys.objects'.
When I run this query:
USE master
SELECT sys.objects.name FROM PBC.sys.object...
SQL 2005 is saying my password is too short when I am trying to install a program.
I have used this password on other programs, and even tested it by creating a ODBC link using SQL login
How can i Alter a SQL table to change an existing Unique keys properties for example i wish to change the "Type" and "Is Unique" property values using SQL Syntax/Query.
Thanks
Hello,
I'm trying to create a dataset for an SSRS report that will retrieve the top 10 customers for each store Not just the top 10 in the table.
I tried to use the Over, Partition By but ...
Hi,
I'm trying to get a SQL server job to send me an email when the job fails. Although I managed to set this up on one server, I'm having issues with this one. Here are the symptoms:
1....
Board Reply
---------------- ---------------------
BoardID (PK) ReplyID (PK)
Subject BoardID (FK)
Registe...
How do i list all the schemas in a database in SQL server 2005?
The below code throughs the "may cause cycles or multiple cascade paths" error. What is strange is that it thinks that the fk_quo_proj and fk_quo_bidproj are referencing the same cascade path....
Can anyone help with the TSQL code need to generate an xml file, in the below format? We are using SQL 2005.
Assume data is in single table, zzTemp, with 2 columns:
Item Offer
A23 70...
how do Add a total row to in a store procedure, my query show;
meses enero febreo
item1 100 200
item2 150 250
I need to show
meses enero febreo
item1 100 200
item2 ...
I just made a update statement using Query analyzer. The result returned was 1200 rows affected. I was expecting 900 rows from using the same select statement earlier. How can I see exactly wh...
Could someone please tell me what I'm doing wrong please. I have tried it so many ways.
I just want to update one column based on the value held in another column.
Here's what I've tried, or...
I am trying to do advance search on my database on multiple tables.
The user will enter the search term and select whether they want ALL
words or ANY one words.And""" ALSO USER WILL SELECT F...
ok in sql server 2005 this would be restoring from a backup that is already present on the hard drive
In sql server management console - right mouse database name select tasks - restore - d...
Hi,
Below is code to get the total transaction price per week from my SQL 2000 database. I am trying to get the total in a pivot type of results, because I am eventually exporting this from...
I'll start my problem with a table schema example:
--Current Table
TABLE_A
COLUMN_1 COLUMN_2
55555|11111|33333| AAAAA
77777 ...
