Wednesday, May 15, 2013

[SQL Server] Configure 'Allow Updates'

[SQL Server] Configure 'Allow Updates'

Configure 'Allow Updates'

Posted: 15 May 2013 12:57 AM PDT

hi there, hope in your help.I tried this code in sql server, but I've this error.Can you help me?I would really appreciate any help.[code]sp_configure 'Allow Updates', 0;RECONFIGURE WITH override;EXEC master.dbo.sp_configure 'show advanced options', 1 RECONFIGURE EXEC master.dbo.sp_configure 'xp_cmdshell', 1 RECONFIGURE EXEC xp_cmdshell 'bcp "SELECT * FROM [dbo].[tbl];" queryout "\\XX.XX.XX.XX\output.txt" -T -c -t;'SQLState = 08001, NativeError = 2Error = [Microsoft][SQL Server Native Client 10.0]Named Pipes Provider: Could not open a connection to SQL Server [2]. SQLState = 08001, NativeError = 2Error = [Microsoft][SQL Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.SQLState = S1T00, NativeError = 0Error = [Microsoft][SQL Server Native Client 10.0]Login timeout expired[/code]

automate estore database into database with a different name

Posted: 15 May 2013 03:48 AM PDT

I currently have 2 databases on the same server: MAPA and MAPA2.MAPA is being backed up nightly as part of a scheduled maintenance plan in SSMS. I need to be able to have an automated process, that I can schedule, that will take the latest backup file from the MAPA database and restore it into the MAPA2 database.Is there a simple way that I can do this?

What would you do?

Posted: 15 May 2013 01:22 AM PDT

Virtualisation again, sorry! I have done a search but this is more about how to handle a particular issue at work so I'm hoping some of you might have some advice please.I need to move a particular (fairly critical) application off its ancient servers and onto something new and a bit more stable. The systems team is involved on the hardware side of things. The head of systems is absolutely mad for virtualising everything, and though he knows a lot about his subject I'm sure, he knows very little about the specific requirements of SQL Server.The documentation produced by the software vendor specifically says (emphasis mine);[quote]Virtualised servers can be used for the application and web tiers of the [product name]. [b]For performance reasons it is highly recommended that database servers are [i]not[/i] virtualised.[/b][/quote]The head of systems says "Bah, we'll do it anyway", but he won't be the one supporting this critical database if it goes wrong. What would you do? Stick to your guns and insist that the database sits on a physical machine, or not?

Copy table+values from one server to another

Posted: 15 May 2013 12:12 AM PDT

This might be the dumbest question ever, but I really don't know/remember how this is done.Let's say you've got 2 servers, S1 and S2. In S1 you've got the [u]source table with the values[/u] you want to transfer to a target table in S2. Assuming S2 already has the table created (easily done by Right click>Script table as...>CREATE), how do you copy one table to another?I thought this was as easy as using the Script table as...>INSERT, but that doesn't work: it throws an error, and when you are on a different server the values don't display after the VALUES reserved word.I know I can import the data, but what I'd like is to copy the data using SQL and referencing server S1.Any suggestions on how to do this? Thanks,

mdf file growing

Posted: 14 May 2013 08:32 PM PDT

Hi,I am new in SQL Server. I have a database whose size is almost 25 GB, there log size 18 GB and mdf file is 6.30 GB, and everyday millions of records is coming and every hour data file size is increasing around 1 MB. Is this a normal , if not can anyone tell me the soluntion.Thanks in advance....

Understanding Errors

Posted: 14 May 2013 10:27 PM PDT

I have this sqlquery that I am writing:[code="vb"]Private Sub Command1_Click () Dim Irepsonse as Integer Iresponse = msgbox("press a button", vbabortretryignore, "Chapter 4")Select Case iresponse Case vbabort Me.lblresponse.caption = "You pressed abort." Case vbretry Me.lblresponse.caption = "you pressed retry." Case vbignore Me.lblresponse.caption = "you pressed ignore."End SelectEnd Sub [/code]But when trying to run it I get an error string that says:Msg 102, Level 15, State 1, Line 1Incorrect syntax near 'Command1_Click'.Msg 156, Level 15, State 1, Line 6Incorrect syntax near the keyword 'Case'.Msg 102, Level 15, State 1, Line 17Incorrect syntax near 'Sub'.How am I supposed to know where the errors are since I dont know what msg, level, or state mean?
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog