Viewing 15 posts - 4,531 through 4,545 (of 7,191 total)
Are you sure the database is SQL Server? That query has a few pieces of syntax that I don't recognise. Just as a matter of interest, why and...
May 17, 2012 at 2:07 am
Please start a new thread. People are less likely to be looking at a seven-year old topic than a new one.
John
May 17, 2012 at 1:32 am
That isn't an error, it's a CREATE DATABASE statement. Is that what you get when you press the Script button in the Restore Database window? No RESTORE statement?
Now,...
May 16, 2012 at 9:09 am
So are you saying that if you look on the disk, the file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\BGPhoenix.mdf doesn't exist? If that's the case, then I imagine you're trying to...
May 16, 2012 at 8:39 am
There must be another database that's using the same physical file names. Use the WITH MOVE clause as the error message suggests, and it should work.
John
May 16, 2012 at 8:18 am
I've never attempted it myself, but you could try writing a custom report that you invoke by right-clicking on Tables and choosing Reports -> Custom Reports.
John
May 15, 2012 at 7:40 am
Shovan
No, there are two separate options for the cluster resource, which, from memory, are Initiate Failover and Take Offline. The former will fail the resource (the whole group, I...
May 14, 2012 at 4:46 am
Shovan
Go into Cluster Administrator, take the SQL Server resource for the instance in question offline, then bring it back online. Don't forget to ensure that SQL Server Agent starts...
May 14, 2012 at 2:51 am
I would nearly always advise the SSIS route. It's more flexible and it enables you to do transformations that you can't (easily) do with T-SQL. It's also easy...
May 11, 2012 at 8:59 am
The best thing to do here is to look up the syntax for cursors in Books Online, have a go at writing it yourself, and post back if there's anything...
May 10, 2012 at 1:49 am
As far as I remember, Filestream isn't available in SQL Server 2005, so you're probably stuck with storing images in the database. You could purchase some document repository software...
May 10, 2012 at 1:44 am
Sum up your order lines before joining to Orders, something like this:
with Orders
as (select 1 Id,
...
April 27, 2012 at 4:33 am
Case solved. You need to post on an Oracle forum.
John
April 27, 2012 at 4:13 am
Viewing 15 posts - 4,531 through 4,545 (of 7,191 total)