Viewing 15 posts - 1,156 through 1,170 (of 1,655 total)
As I wrote before it's in BOL. Just look for SQL express features.
Markus
September 21, 2007 at 2:38 am
From BOL:
The following list highlights the major SQL Server 2005 components that are not supported in SQL Server Express:
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,...
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
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...
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...
September 20, 2007 at 7:08 am
Did you look here ? https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=5395
Markus
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...
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...
September 19, 2007 at 12:51 am
You need to query the registry.
DECLARE
@DefData nvarchar(200)
EXEC
master.dbo.xp_instance_regread
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...
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...
September 18, 2007 at 3:24 am
Sameer,
as a starter have a look into the performance guide from MS.
Markus
September 17, 2007 at 8:50 am
Kyle,
I usually use
IF CONVERT(char(1),SERVERPROPERTY('ProductVersion'))<'9'
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...
September 14, 2007 at 3:57 am
Viewing 15 posts - 1,156 through 1,170 (of 1,655 total)