Viewing 15 posts - 1,156 through 1,170 (of 1,654 total)
From BOL:
The following list highlights the major SQL Server 2005 components that are not supported in SQL Server Express:
[font="Verdana"]Markus Bohse[/font]
September 21, 2007 at 2:10 am
Frances,
I don't see any problem. When I try your original procedure the records are all inserted into the table. Tried it 6 times, got 6 records in the table.
About the CAST,...
[font="Verdana"]Markus Bohse[/font]
September 21, 2007 at 1:11 am
Abhijit is right.
The SSMS report should show any schema changes, when and by whom. Another alternative is the default trace which is running with SQL 2005.
Markus
[font="Verdana"]Markus Bohse[/font]
September 21, 2007 at 12:57 am
Pieter,
when your using SELECT INTO, your running an implicit CREATE TABLE statement. Datawriter only means that a user can insert, update or delete records in existing tables or views. He...
[font="Verdana"]Markus Bohse[/font]
September 20, 2007 at 7:53 am
The behaviour you're seeing is perfectly normal and intended. The DENY overruling andy over grants only applies to grants on the same object.
For example if your testuser is also memebr...
[font="Verdana"]Markus Bohse[/font]
September 20, 2007 at 7:08 am
Did you look here ? https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=5395
Markus
[font="Verdana"]Markus Bohse[/font]
September 19, 2007 at 4:14 am
Sisir,
I makes no diference which OS you're using. What is important is the SQL Server version and what you mean by "Importing". Since you talk about Publishers and subscribers I...
[font="Verdana"]Markus Bohse[/font]
September 19, 2007 at 1:55 am
John
applying a service pack will cause some downtime, no matter what hardware or configuration you have because you need to restart the services.
With database mirroring you could failover...
[font="Verdana"]Markus Bohse[/font]
September 19, 2007 at 12:51 am
You need to query the registry.
DECLARE
@DefData nvarchar(200)
EXEC
master.dbo.xp_instance_regread [font="Verdana"]Markus Bohse[/font]
September 18, 2007 at 6:29 am
Interesting question I think.
While I see loads of scripts which first check "if exists then drop" I usually argue it's better to use ALTER in case an objects already...
[font="Verdana"]Markus Bohse[/font]
September 18, 2007 at 4:26 am
David,
a full backup won't do anything with your Tlog.
You need to backup the transaction log in order to mark parts of the tlog as inactive so that they...
[font="Verdana"]Markus Bohse[/font]
September 18, 2007 at 3:24 am
Sameer,
as a starter have a look into the performance guide from MS.
Markus
[font="Verdana"]Markus Bohse[/font]
September 17, 2007 at 8:50 am
Kyle,
I usually use
IF CONVERT(char(1),SERVERPROPERTY('ProductVersion'))<'9'
[font="Verdana"]Markus Bohse[/font]
September 17, 2007 at 8:11 am
Jai,
as you can find in several other posts on tyhis site, you the best place to handle date formats is the client application not the server. It's not important...
[font="Verdana"]Markus Bohse[/font]
September 14, 2007 at 3:57 am
Joe,
either use CTRL+ R or add the Show/Hide results button to your toolbar. You find it under Tools\Customize in the Windows categorie.
Markus
[font="Verdana"]Markus Bohse[/font]
September 14, 2007 at 2:58 am
Viewing 15 posts - 1,156 through 1,170 (of 1,654 total)