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
...
|
authentication failures coming from sqlserver
Thu, 3 Jul 2008 16:03:07 +0100
Hi,
I'm having a problem whereby an admin account is getting locked out. In the
security log on the domain controller I'm getting lots of "logon failures"
stating that the source machines are our sql servers.Given that the servers
run sql and not much else I can only assume that the errors are coming from
...
|
SELECT TOP and ORDER BY
Thu, 3 Jul 2008 10:50:50 +0200
Hello,
I'm using an MS SQL Server 2000 and I have a problem with this select
statement:
SELECT ST.OrderNr,ST.Version
,Skylt.BatchNr, Skylt.SkyltNr, Skylt.Layout, Skylt.Antal,ST.TidProducerad
, CASE
WHEN ST.Laser = 0 OR ST.Laser IS NULL THEN 'Laser 1 eller 2'
WHEN ST.Laser = 1 THEN 'Laser 1'
WHEN ST.L ...
|
installing a new named instance on remote server
Wed, 2 Jul 2008 12:13:58 -0500
I did this for a MOSS 2007 small farm, but I think I may be "illegal".
Background: DC is running SBS 2003 Premium SP1 - which comes with SQL 2000
bundled in. Second server runs Windows Server 2003 SP2 R2, and has MOSS 2007
installed on it. What I want to do is take advantage of the SQL server on
the SBS bo ...
|
MSSQL Client Autoreconnt
Wed, 2 Jul 2008 09:21:43 +0100
Hi all
The MS SQL client for SQL2005 does not seem to have an inbuilt
auto-reconnect feature ?
We have an app that connects to a remote SQL server which works fine on a
wired connection but over wireless there seems to be no fault-tollerance at
all. So the slightest blip on the Wifi connection and it fal ...
|
|
|
MSg 156, Level 15, State 1 error
Tue, 1 Jul 2008 14:42:03 -0500
I am trying to execute the following query using MS SQL Server Management
Studio (version 9.00.2047.00) on a Windows Server 2003 R2 SP2 Enterprise
operating system:
select u.QuotaID, ab.purse,
coalesce(ab.Balance,0) + coalesce(ab.PurgedBalance,0) +
coalesce((select sum(Debit-Credit),0) from TranLedger ...
|
ASP, Ampersand, Detailsview, escape sequence No data
Tue, 1 Jul 2008 11:16:57 -0700 (PDT)
I am having a problem with data being pulled back when the data field
being used to filter
a query contains an ampersand and not data gets returned to the
detailsview in an ASP page.
Example query:
Declare @Company_Name NVARCHAR(5)
Set Company_Name = 'Bob & George Used Stuff'
Select * from Company_Da ...
|
sql agent JOB to Backup Database and Maintain Backup Files
Mon, 30 Jun 2008 12:19:06 -0700 (PDT)
Hi friends,
How can I create ONE SQL Agent JOB That will 2 activities: (Using SQL
2005)
1) Backup a specified Database (Full Backup) and store the backup file
in a Specified FOLDER.
2) Manage the Backup Files in the FOLDER, ie. Delete the files that
are 5 week OLD.
I want to schedule the JOB to run ever ...
|
