Restore Problem
Mon, 14 Jul 2008 15:13:41 +0100
Hi
I have used the backup option on one server to create a .bak of a database
I copied over to another server and then tried to use the restore option but
whatevever I tried I got error 5 access denied on the .bak file
I am logged in as administrator an as far as I can tell I have full control
on both t ...
|
Can't figure out Stored Procedures
Thu, 10 Jul 2008 16:34:42 -0500
SQL 2000 SP3a; named instance: WCTIntranet
DC: Windows Small Business Server 2003 Premium SP1
Application Server: Windows Server 2003 R2 SP2
The DC has SQL bundled in it. I want to place the database files/logs on
the Application Server (were I have MUCH more room).
I deleted the sample databases. I have ...
|
Transfer of records from one table to another
Thu, 10 Jul 2008 12:02:39 +0200
Hi....
I have a problem ensuring the integrety of a move between som busy tables.
I basically have a buffer table into which different processes are
delivering data, these records comes in via some odbc conenctions in random
order, and the number of records can vary from 1 to more than 100.000
between th ...
|
Cannot find server
Thu, 10 Jul 2008 11:30:09 +0930
I have sqlserver2005 running with a database and its working fine, i have
tried to load a new piece of software that also uses sqlserver and it seems
to install fine and setup using port 1004. The problem is when i install the
client side and try to link to the server it cannot find the server, the
network i ...
|
Connecting for the first time
Wed, 9 Jul 2008 13:59:06 -0500
I just installed SQL 2005 Standard on a a Windows Server 2008 Virtual PC
instance. During installation, I mostly chose default settings, telling it
to use Windows Authentication, and the default instance name, which I
believe means it used the machine name for an instance name.
I just started up Management ...
|
Multiple options query question
Tue, 8 Jul 2008 22:06:32 +0100
Hi
I have a Clients table with a 'status' field with possible values; Current,
Inactive and Prospect. I want to return values either on one of the values
of status field or all records. My questions are;
1. Is stored procedure the best way to handle this query? If so what is the
construct of such a store ...
|
Cannot Install "Reporting Services"
Sun, 6 Jul 2008 22:26:18 +0800
I am installing SQL Server 2005, Developer Edition. My computer is Window
Vista Home Premium SP1
However, the "Reporting Services" cannot be installed ( the check box is
Grey Color in the "Reporting Services" area, cannot be selected )
Why I cannot install "Reporting Services" ? How to solve this problem? ...
|
|
|
xp_cmdshell delete file/copy
Sat, 5 Jul 2008 17:35:27 +0200
DECLARE @statement NVARCHAR(128)
SET @statement = 'EXEC xp_cmdshell ''copy C:\Temp\SQLTesting\Cycles.xls ' +
'C:\Temp\ ' + ''''
EXEC sp_executesql @statement
Why this scripts don't work on SQLExpress 2005,on result i have ACCESS
DENIED,why???
Thanks advance.
...
|
How do you create a SQL Server Express database
Sat, 5 Jul 2008 01:26:51 -0500
I would like to create databases as individual files.
I want my WPF application to create individual files like Excel has
individual files.
Thanks
Barry
...
|
viewing timestamp fields
Fri, 4 Jul 2008 14:16:53 +0100
Hi all
The SSMSE shows timestamp fields as "Binary Data"
How do you view the actual date and time stored in this field ?
Thanks
Andrew
...
|
