I'm facing the below error, can you help me with this
SQLState = 37000, NativeError = 40054
Error = [Microsoft][SQL ServerNative Client 11.0][SQL Server]Tables without a c
lustered index are not supported in this version of SQL Server. Please create a
clustered index and try again.
Dear Wayne (and all) -- Please help. I do not have permissions to create a Stored Procedure or a Table in my current project role. Is there a way to do this Circular Reference check without such permissions? Please advise. Thanks. -- Mark Kamoski
I thought horizontal partitioning was about grouping / normalization and vertical partitioning was about identical distributed schema with rows split according to some function. Just think of it. "Horizontal" is references between relationships and vertical is intra - relationship ( or intra - table ) rows. It sure sounds confusing...
PLZ TELL ME HOW TO CRATE DATABASE FROM SCRIPT IN MANAGEMENT STUDIO
This is not working. I am still getting the following error.
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
This is awesome information. I missed this one simple step, targeting the script for SQL Azure.
I thought you and some of your readers would be interested in the dashboard I just created which shows aggregated connection times and performance for all of the customers databases we monitor split out by data center (www.cotega.com/.../AzureSQLDatabaseStatus).
How can I pull in a temp table using a file that is currently on my desktop?
Typo alert: "-i –N CreateDatabase.sql" s/b "–N -i CreateDatabase.sql"
why are all these examples for web.config. In an azure worker role that needs to connect to SqlAzure instance, I don't even have web.config. Isn't cscfg the right spot to store settings? what if I want to change the connection string without redeploying application? Do you have link to sample for how to store encrypted connection string to cscfg file?