Viewing 15 posts - 61 through 75 (of 137 total)
Also, in the article about the stored proc sp_db_vardecimal_storage_format it says it does not have to be enabled:
Starting with SQL Server 2008, user databases are always enabled. Enabling databases...
May 10, 2016 at 7:55 am
Steve Jones - SSC Editor (5/4/2016)
timwell (5/3/2016)
Maybe this is cheating, but one of the top items in my google search was Steve's recent blog post about it:http://www.sqlservercentral.com/blogs/steve_jones/2016/04/25/explicitly-using-tempdb-with-tables/
Kind of cheating. I'd...
May 4, 2016 at 7:32 am
Maybe this is cheating, but one of the top items in my google search was Steve's recent blog post about it:
http://www.sqlservercentral.com/blogs/steve_jones/2016/04/25/explicitly-using-tempdb-with-tables/
May 3, 2016 at 7:20 am
Luis Cazares (3/28/2016)
Shouldn't the policy send the username column like this?
CREATE SECURITY POLICY rls_CustomerFilter
ADD FILTER PREDICATE dbo.rls_customer_check(username)
ON dbo.CustomerAccessList;
GO
I had a similar question. I guessed that it would...
March 28, 2016 at 7:32 am
We are using 2008 R2. Do those same restrictions apply there? I do not see anything like that on the vmware page for that.
https://solutionexchange.vmware.com/store/products/microsoft-sql-server-2008-web-edition
March 23, 2016 at 7:53 am
Eric M Russell (3/22/2016)
March 22, 2016 at 3:07 pm
Wayne West (3/21/2016)
March 21, 2016 at 1:49 pm
Andy Warren (3/21/2016)
March 21, 2016 at 9:32 am
kiwood (3/21/2016)
March 21, 2016 at 9:16 am
Gqmobile (3/21/2016)
March 21, 2016 at 8:59 am
clb39 (3/21/2016)
...How often are errors added to the table?
In the entire time it has filed 48 error rows, all of them "possible concurrency errors" because the "Old" value...
March 21, 2016 at 8:53 am
Marius E (3/21/2016)
Maybe you could solve the ID problem using a sequence in the master database, that you query before adding a new row on the remote databases?
Thanks,...
March 21, 2016 at 8:45 am
The explanation does not explain why the DBCC CHECKIDENT(table) returns null after TRUNCATE TABLE
I would have expected it to show the seed value (whatever it was. It was not stated.)
March 10, 2016 at 7:34 am
TimCarrett (3/4/2016)
Ok so don't use windows calculator to try to calculate this. I can now see my mistake.Good question, poor calculator skills.
Worked OK for me after switching to View /...
March 4, 2016 at 7:19 am
Thanks Michael for doing this article. I thought it was a good explanation and example.
However I was also distracted by the window/windows difference and some typos / misspellings.
Here are a...
February 17, 2016 at 8:16 am
Viewing 15 posts - 61 through 75 (of 137 total)