Viewing 15 posts - 6,376 through 6,390 (of 7,168 total)
Sounds like a DENY may be in place.
What does this return?
USE [DBname]
GO
SELECT perms.*,
users.name
FROM sys.database_permissions perms
...
May 23, 2011 at 11:23 am
armm1388 (5/22/2011)
hi'In a database project which use of pictures, Is it better to save pictures in database or to file?
thanks very much
It depends on many things. FILESTREAM is an option....
May 23, 2011 at 11:13 am
(2)if file exist,use Script task to split the file into multiple files dynamically, i.e. all ACC records will goes to Accout.txt and so forth.
I would not use a Script Task...
May 23, 2011 at 10:56 am
dankwart menor (5/22/2011)
UPDATE pSET name = i.name,
some_other_field = i.some_other_field
FROM inserted i
JOIN dbo.productsxy p on i.id = p.id ;
And...
May 23, 2011 at 10:32 am
Thanks for the post back. Keep sequences in mind when you upgrade to SQL 11 (code named "Denali")
...you just manually implemented Example D from this article:
http://msdn.microsoft.com/en-us/library/ff878058%28v=SQL.110%29.aspx
May 23, 2011 at 10:08 am
Koen Verbeeck (5/22/2011)
opc.three (5/20/2011)
Also, how...
May 23, 2011 at 9:54 am
Koen Verbeeck (5/22/2011)
http://www.sqlservercentral.com/Forums/Topic999328-148-1.aspx
Point 1: I don't see an issue with that at first sight. I use it myself from time...
May 23, 2011 at 9:54 am
You can do it one statement using the OUTPUT clause. See Example F in this article: http://msdn.microsoft.com/en-us/library/ms177564.aspx
May 20, 2011 at 7:35 pm
In relation to users what is the difference between adding users in
Servername>Security>Logins and Servername>Databases>Databasename>Security>Users in the object explorer window of sql server 2005.
To clarify some terminology there are no...
May 20, 2011 at 4:20 pm
abygaikwad17 (5/19/2011)
May 20, 2011 at 3:07 pm
Ed Zann (10/6/2010)
May 20, 2011 at 2:09 pm
Credit to this article:
http://www.sqlservercentral.com/articles/T-SQL/63681/%5B/url%5D
USE tempdb
GO
IF OBJECT_ID(N'tempdb..#SomeTable1') > 0
DROP TABLE #SomeTable1;
GO
CREATE TABLE #SomeTable1
(
AcctNum INT,
InsCode INT,
InsName VARCHAR(100)
)
GO
INSERT INTO #SomeTable1 (AcctNum, InsCode, InsName)
...
May 20, 2011 at 11:17 am
We are "planning to upgrade soon" even if an SP is not released...but that was not an option in the poll so I answered No :hehe:
May 20, 2011 at 11:01 am
Viewing 15 posts - 6,376 through 6,390 (of 7,168 total)