We installed SQL Express that came with MOSS 2007. We purchased SQL Standard and want to upgrade the Express version to the Standard. The SQL Server 2005 Express Edition is version 9.00.2047...
My Replace() string function in he query below for objRecordSet("Message") just wouldn't work on SQL Server 2005. This recordset has unicode character string NTEXT. I have tried using the foll...
In SQL Server 2005 Reporting Services, system admin can run reports from the RS web interface by clicking a report link; users can see the report link but get error when click link. Error is ...
Hello Experts,
Is there a SQL function that will strip out unwanted characters from a text Column in a SQL 2005 table//
For istance... I have a VarChar(4) column that holds time value r...
I have a table (tblMonthSales) showing Month, brand, customer, product, qty, value. At the moment i have an excel Pivot sheet which uses this SQL Server table as a datasource to create a shee...
Created a stored procedure with the following statments
declare @SqlQuery
@SqlQuery = 'select * into #test from dept'
execute sp_executesql @SqlQuery
select * from #test
If I execute th...
Hi,
I have the following source code from a webpage: -
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>90/IP</title>
<meta http-equiv="Content-Ty...
How can I connect to a MS Access 2007 database using SQL Server 2005 Management Studio?
I am using SQL Server 2005 Reporting services, I need to set up a suscription for a report such that if the report is empty, I need to add a note in the email , stating that the report is empty.
In SQL Server 2205 Reporting Services I am trying to create a date parameter that gives these selections:
Last 7 Days (last 7 days including today)
Last 3 Days (last 3 days including t...
I've created a database copy job as a DTS Package using the Copy Database Wizard in sql2005. How do I Export(?) this job to a .dtsx file.
Here is what I can see from sql jobs under command line tabs, what can I do to execute this from windows command line?
/FILE "C:\Packages\BOLA.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF
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 ...
Hello,
I recently performed an upgrade on my SQL server; from SQL 2000 to SQL 2005. The upgrade went smooth and I had no issues after the process successfully completed. After a reboot an...
Hi,
I am using SQL 2005
I am using the function newId() as a default value when records are inserted into the database table. After I insert a record, how can I retrieve the id of the l...
i have an sql 2008 database that i am trying to backup then restore to a 205 database on another server.
I can back them up properly but when i try to restore them on another server i get a...
Hi everybody:
I wanted to know how can I restrict access to my sql server 2005 database so that a login can only query a view. I have about 5 views created and I want a developer to only ...
If were doing this in Classic ASP, I'd have no problem. But in SQL Server, I can't get this to work right.
Basically, I'm trying to build a dynamic update statement. So the parameters would...
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...
I have 4 tables
1) test_t1. Columns: t1Id and wId.
2) test_t2. Columns: t2Id and wId.
3) test_w. Columns: wId and Word. A table with words that the first two tables refer to.
4) tes...
Hi
I am trying to export a view to a .csv using a script, but when I open the .csv there are no colum headers.
Also the Colum I identifier is a tab, how do I change this to a ,
The s...
I have a program that installed a SQL Express 2005 DB on my old computer. I am moving to a new computer and need to move this DB to it.
I have installed the program on the new computer, but...
Does anyone know how to setup MediaWiki using Microsoft SQL server 2005 instead of MySql?
We are using a stored procedure to execute a script that copies files on our network. This is called from our inhouse database that each user needs access to. Having read numerous articles o...
Hello
I want to know the easiest way to disconnect all current user that may using a specific databse
in sql server 2005
