Forum Replies Created
Viewing 15 posts - 37,261 through 37,275 (of 39,720 total)
-
RE: SQL server Service Manager.
Go into Control Panel, Admin Tools, Services and check the account under which SQL Server runs. It's not the account you log in as.
Steve Jones
-
RE: what happens when you change a table?
Most changes require a rebiuld of the table because the physical structure changes. If you change the table in EM, the third button from the left is a script button....
-
RE: File Groups
yes, you rebuild the index and you can specify the filegroup.
http://msdn.microsoft.com/library/default.asp?url=/nhp/default.asp?contentid=28000409
note the ON clause.
Steve Jones
-
RE: File Groups
Moving the clustered index should do this. I'd be sure you save the changes, shut down EM and then go back to be sure it refreshes.
Steve Jones
-
RE: SQL Server 2000 & MSDE 2000 on same machine?
Nothing I know of, but I suspect you can do this, but the SQL (rgular) install will be an instance.
Steve Jones
-
RE: SP Security Administration
You will save headaches as Brian mentioned. ALWAYS use roles and groups. NEVER assign individual users.
Steve Jones
-
RE: Programming to run like Profiler?
What do you mean? Run profiler programmatically? This can be done. There are stored procedures to run server side traces.
Steve Jones
-
RE: Putting 7.0 db files into 2000
I believe you can restore or attach a SQL 7 database, but you'd have to try. Can't hurt.
You do not need to run "sp_change..." unless you need the users. You...
-
RE: Recover Database marked as Suspect?
Thanks for answering
Steve Jones
-
RE: Stored Proc Question
search google with "decrypt stored procedure"
Steve Jones
-
RE: INSERT taking long to execute
Are these a single transaction?
Check the log and data phyiscal location, you may have a hardware issue.
Are you sure this is hte only index?
Steve Jones
-
RE: select statement to get max year
max should give you the max date. Are these character values?
you can do max(datepart(year, value))
Steve Jones
-
RE: SP Security Administration
You will need to assign the execute right, but you can create your own role to do this and assign the users to the role. It can be a user...
-
RE: Object ID in which Database?
This is a page id from the pages stored in the db. You can get the objectid from each database and query each table (Select *). One should give you...
-
RE: 4.2 to 6.5 Conversion
Not sure about this one.
Steve Jones
Viewing 15 posts - 37,261 through 37,275 (of 39,720 total)