Forum Replies Created

Viewing 15 posts - 316 through 330 (of 1,409 total)

  • RE: extracting and manipulating date from a table

    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...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    October 5, 2014 at 2:29 pm

    #1750200

  • RE: What permissions are necessary to issue "ALTER TABLE ? NOCHECK CONSTRAINT ALL"

    jayrocks20 (10/2/2014)

    I have a selfreferenced foreignkey table . Deleting records from this table is complicated.

    I am using a CTE to fetch all child records to be deleted together to avoid...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    October 2, 2014 at 4:54 am

    #1749645

  • RE: How to apply patches in SQL server 2005 Active/passive cluster

    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...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    October 2, 2014 at 1:55 am

    #1749602

  • RE: How to find unused stored procedures in sql server

    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...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    October 2, 2014 at 1:16 am

    #1749595

  • RE: Permissions to run report

    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...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    October 1, 2014 at 2:44 pm

    #1749545

  • RE: Permissions to run report

    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...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    October 1, 2014 at 1:49 pm

    #1749523

  • RE: What authroities are needed for user

    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...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    October 1, 2014 at 8:20 am

    #1749408

  • RE: Are the posted questions getting worse?

    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...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    October 1, 2014 at 3:38 am

    #1749339

  • RE: Permissions to run report

    HanShi (9/30/2014)

    Did you setup a linked server for that? If so: the stored procedure will read the data from the other server using the authorization defined in the linked server...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    October 1, 2014 at 1:19 am

    #1749312

  • RE: Permissions to run report

    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...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    September 30, 2014 at 2:02 pm

    #1749260

  • RE: installing SQL Server 2008 R2 Standard Edition on Windows Server 2012

    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...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    September 30, 2014 at 1:56 pm

    #1749258

  • RE: Are the posted questions getting worse?

    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...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    September 30, 2014 at 7:05 am

    #1749123

  • RE: want to run a query which will give the Admin detail

    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...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    September 30, 2014 at 6:21 am

    #1749108

  • RE: To start a SQL Job after one other SQL job is completed

    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...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    September 29, 2014 at 7:46 am

    #1748814

  • RE: How to Transfer Logins to Another SQL Server

    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.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    September 29, 2014 at 7:17 am

    #1748802

Viewing 15 posts - 316 through 330 (of 1,409 total)