SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Gokhan Varol / System proc sp_SysInfo to get / Latest Posts

RE: System proc sp_SysInfo to get

gvarol — Thu, 01 Mar 2012 12:54:17 GMT

try to copy and paste into word first and then paste it to notepad to see if the off characters are removed then copy it to management studio.

RE: System proc sp_SysInfo to get

ericb1 — Thu, 01 Mar 2012 12:42:58 GMT

when trying to copy and paste this script into my SQL manager studio, it gives me a ton of "Incorrect syntax near ' '." errors due to the characters spaces in each line. Am I copying this wrong from the site, or is there an easier way to remove these so the script will run?thanks!

RE: System proc sp_SysInfo to get

gvarol — Tue, 28 Feb 2012 11:29:17 GMT

A sample if you need it--SQL2008++DECLARE @i INT = 5, @k INT = 6GO--SQL2005++DECLARE @i INT, @k INTSELECT @i = 5, @k = 6GO-- SQL2005++DECLARE @i INT, @k INTSET @i = 5SET @k = 6

RE: System proc sp_SysInfo to get

gvarol — Tue, 28 Feb 2012 11:22:47 GMT

sql 2005 does not allow assigning values to a variable during declaration. You can have the declare done first and then assign the values to the declared variables.I have not tested this script on sql 2005, I do not have one setup. If things do not work as a complete package in sql 2005 you can get rid of the pieces that does not work and use the rest if you'd like.

RE: System proc sp_SysInfo to get

ericb1 — Tue, 28 Feb 2012 09:53:02 GMT

trying to save this as a stored procedure in SQL2005, but am getting an error: Cannot assign a default value to a local variable.Any help is greatly appreciated, thanks!

System proc sp_SysInfo to get

gvarol — Mon, 20 Feb 2012 22:48:03 GMT

Comments posted to this topic are about the item [B]System proc sp_SysInfo to get [/B]