Viewing 15 posts - 271 through 285 (of 568 total)
Hello,
Did you see this TechNet article:-
http://technet.microsoft.com/en-us/library/ms190181(SQL.90).aspx
Regards,
John Marsh
February 28, 2009 at 8:07 pm
Hello,
Are you getting any related errors in the Windows Event Logs, or displayed in the Replication Monitor?
If it is related to (Merge) Conflict Resolution then this BOL Topic shows you...
February 28, 2009 at 7:47 pm
Hello,
A couple of T-SQL statements to try from a query window connected to the DB in question:-
Select * From INFORMATION_SCHEMA.TABLES
Do you get a list of the Tables that you were...
February 28, 2009 at 7:32 pm
Hello,
Did you lookat using DB Detach/Attach instead of Backup/Restore? It would be more efficient if it worked.
Regards,
John Marsh
February 26, 2009 at 8:58 pm
Hello,
Do you have SSIS Logging configured for the Job Step? Any useful diagnostics captured there that you could post?
Alternatively, just for bug hunting you could convert the Job Step to...
February 26, 2009 at 5:11 pm
Hello,
May be take a look at this article:-
Regards,
John Marsh
February 25, 2009 at 9:57 pm
Hello,
It is a good idea to (always) use Scripts to deploy to your Prod environment, that way you can also apply them to your DR Site, and keep things in...
February 25, 2009 at 9:06 pm
Hello,
Being European I’ve never modelled baseball before, so it was vaguely interesting to give it a go.
Entities can be discovered from the major nouns in the problem description, but you...
February 25, 2009 at 8:53 pm
Hello,
May be take a look at Mark Han’s posts to this thread:-
http://www.devnewsgroups.net/group/microsoft.public.sqlserver.tools/topic66541.aspx
It looks like "SQL Server Remote Setup" is an orphaned job from a SQL Installation and (assuming...
February 25, 2009 at 8:31 pm
Hello,
You are missing a couple of commas at the ends of your Column definitions in the Create table dbo.TestHistory statement.
If you are using SSMS you can double-click the Error Message...
February 25, 2009 at 8:14 pm
Hello,
Are you a member of the sysadmin role on the SQL Server? I suspect you can not see or amend the Step Properties because you do not have a high...
February 25, 2009 at 3:33 pm
Hello again,
Apologies for the delayed response, but I have had a few days holiday.
When you run the failing job with verbose Logging turned on, what is the full error text...
February 24, 2009 at 5:59 pm
Hello again,
I suspect what you are after is the Row_Number function.
Possibly something like:-
Select
customerid ,
Row_Number() Over(Partition By customerid Order By customerid Asc) As serialno,
Product
From
YourTable
Regards,
John Marsh
February 17, 2009 at 5:31 am
Hello,
I would suggest you need to explain your problem more.
Just in case I have correctly guessed what you need: Truncate Table resets an Identity column to its seed value.
Regards,
John Marsh
February 17, 2009 at 12:33 am
Hello,
How big do you expect the Backup File to be, and how much free space do you have on the Target Drive? Is the Target Drive formatted for NTFS or...
February 17, 2009 at 12:22 am
Viewing 15 posts - 271 through 285 (of 568 total)