Viewing 15 posts - 316 through 330 (of 1,409 total)
This is a forum for Microsoft SQL Server, so I don't know if it's compatible. Also you should provide sample code (create table and insert sample rows) and desired output...
October 5, 2014 at 2:29 pm
jayrocks20 (10/2/2014)
I am using a CTE to fetch all child records to be deleted together to avoid...
October 2, 2014 at 4:54 am
Text below is copied from http://blogs.msdn.com/b/glsmall/archive/2013/11/14/best-practise-for-patching-sql-server.aspx
SQL 2005 Clusters
Patching a cluster is slightly more complicated and the process is different fro SQL 2005 than it is for versions later than...
October 2, 2014 at 1:55 am
This is very difficult to determine. You could have stored procedures that only run once a year. If you remove such one, a process will fail when you've forgotten you...
October 2, 2014 at 1:16 am
ramana3327 (10/1/2014)
No errors in visual studio but from report manager only.
I don't mean look for errors in VS or report manager. Look for errors in the error log on the...
October 1, 2014 at 2:44 pm
Look in the error log of the SQL instance where the linked server is connecting to. Are there any errors at the moment you ran your report?
This could be related...
October 1, 2014 at 1:49 pm
With DB_OWNER role a user is able to do everything within the scope of the database. This includes granting permissions to users!! For creating/altering tables and stored procedure the DB_DDLADMIN...
October 1, 2014 at 8:20 am
Stuart Davies (10/1/2014)
BWFC (9/30/2014)
[snip]
'You work in IT, you run the website', said the committee.
'Err', said I.
I feel your pain - that's how I ended up with the website for my...
October 1, 2014 at 3:38 am
HanShi (9/30/2014)
October 1, 2014 at 1:19 am
How is your stored procedure accessing the data on the other server? Did you setup a linked server for that? If so: the stored procedure will read the data from...
September 30, 2014 at 2:02 pm
according to this post SQL 2008R2 on Windows Server 2012 it should be able to run SQL2008+ on Windows 2012. So I guess your issues are more related to the...
September 30, 2014 at 1:56 pm
In the Netherlands there's a huge movement towards the "new working". More and more medium/large sized companies redisign the office space. It's all open, no cubicles, no borders between the...
September 30, 2014 at 7:05 am
You need to join the mentioned table "tblMain" with the details table (tblMember?). Use the column(s) that defines the relation between these tables in your join statement.
SELECT ...
FROM tblMain
INNER JOIN...
September 30, 2014 at 6:21 am
Koen Verbeeck (9/29/2014)
SQL-DBA-01 (9/29/2014)
SSCrazy,I dont think what yopu'd suggested would work...as unless the first job is completed, I do not want to start the second job.
If you put that...
September 29, 2014 at 7:46 am
george sibbald (9/29/2014)
google sp_help_revlogin
"sp_help_revlogin" is excellent, especially when you're working with SQL2000. I prefer the query in my previous post when on SQL2005+ because you don't need additional stored procedures.
September 29, 2014 at 7:17 am
Viewing 15 posts - 316 through 330 (of 1,409 total)