You searched for the word(s): userid:693985

More Search Options

RSS Available

• Re: Managing SQL Server remotely

  Thank you so much. I'm going to go in tomorrow and try it out. You'll probably be hearing back from me.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by mike beal on 6/28/2007

• Re: folders in stored procedures folder pls help

  I'm sure I'm not following you 100% but I wouldn't disturb how SQL stores your scripts at all. You will end up with one set of scripts in the database and a separate (hopefully mirrored) set on disk. When I go to create a new script and I have a Project full of my scripts opened I don't right click Object Explorer to create my new script I right click the project folder (Solution Explorer) and select new query. I write the query, save it to disk (in the Project) and then execute it

  Posted to Visual Studio 2005 (Forum) by mike beal on 6/27/2007

• Re: folders in stored procedures folder pls help

  I agree. The Projects concept and use doesn't really effect the database directly so I don't see how it could effect any use of the database. As I mentioned besides giving your some organization I do like how you can then do a text search on all the scripts in your project. That feature alone makes me want to use Projects but it's up to you.

  Posted to Visual Studio 2005 (Forum) by mike beal on 6/27/2007

• Re: Regarding auto increment of id in sql table

  I reset the autoincrement with this but I've never tried running it from a stored procedure. DBCC CHECKIDENT ( MyTempTable1 , RESEED , 0 ) You might have to go this route. "EXEC ('DBCC CHECKIDENT(MyTempTable1,RESEED,0)')"

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by mike beal on 6/27/2007

• Re: Managing SQL Server remotely

  So you have been able to connect to SQL off your network usng Management Studio. That is good news. However, I keep getting errors but I probably don't have all my ducks in a row on settings. I tried a raw IP, then raw IP with server name (67.81.4.38/ServerName) and then with the http ( http://67.81.4.38/SeverName ) and still no luck. I get the feeling I need to open a port or two on the server. Some documentation sure would help. I'll keep at it but if anyone knows of some good documentation

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by mike beal on 6/27/2007

• Re: Managing SQL Server remotely

  I can find no place in Management Studio (linked or registered) to enter an IP number? If anyone stumbles on documentation to pull this off I'd sure appreciate it. It appears all references to 'remote' in the help files means within the same internal network. Again, a third party tool is doable.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by mike beal on 6/26/2007

• Managing SQL Server remotely

  I've combed through SQL Help to find the answer to my question but I think it's telling me it can't be done. I work both from an office with my servers and from home. When I'm at home I would like to access my SQL server remotely using a tool such as MS SQL Server Management Studio. But it appears there is no way to access my SQL Server for management purposes using Management Studio over a remote internet connection. I can access the server using Management Studio while I'm on

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by mike beal on 6/26/2007

• Re: Am I doin this right? SELECT / ExecuteNonQuery statement

  In addition to what the prior person mentioned, if all you want to know is that the record exists then query for a count. SELECT COUNT(primaryKey) FROM tblName WHERE ......<add all your where conditions here>. Then you can use ExecuteScalar - much more efficient.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by mike beal on 6/26/2007

• Re: How can I create new instance in my computer or any server ?

  You can install as many instances of SQL Server as you wish on a server. The only limitation I know of is that only one can be the default server and all the others have to have a server name.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by mike beal on 6/26/2007

• Re: Auto increment based on date

  An interesting concept for sure but doesn't this smack of a normalization violation which may be the least of your problems with this idea. I'd keep the date in a separate column and use a normal auto increment. From that you should be able to accomplish just about everything you're trying to do with this unusual idea including presenting the user with a computed column that looks like 'yyyymmdd[order number].' If I just had to succeed with this idea I'd consider writing a

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by mike beal on 6/26/2007