Hello, I am using the following to create the text for granting permissions to stored procedures: USE Train SELECT 'GRANT EXECUTE ON '+ name + ' TO Web_Publish' FROM sysobjects WHERE (type = 'P') AND (category = 0) AND (name LIKE '%web_%') Is it possible to actually grant permissions ...more >>

I have a script that must run in both SQL 2005 and SQL 2000. So beforehand,I want to tell that I cannot use "DROP LOGIN" since SQL 2000 does not support it. The SQL 2005 documentation states that "sp_droplogin" calls "DROP LOGIN" I'm currently logon on the SQL server (DEVDSL1) using the local...more >>

Hi All, I ask the eternal question of what is the best practice to handle log files. I want to and have given the log file to grow so that I have no performance issue. I do backup the database every night. So is the only solution to detach the Server and start a new log file every now an...more >>

Hi, Our application needs to issue an alter table statement. Since the user using the application does not have dbo permission, we are planning to use a stored procedure with dynamic sql. SET @RUNSQL = "alter table dbo.gggg .." EXEC(@RUNSQL) The stored procedure is owned by dbo. However...more >>

Hello, I have a full-text enabled field in my table has the following content as an example: "SQL Server is a comprehensive, integrated, end-to-end data solution that empowers your people by providing a more secure, reliable, and productive platform for enterprise data and BI applications. SQL...more >>

I have a problem with SQL Server 2000 enterprise manager.. I truncated a table and it's now empty but when i see the properties of this table it say Rows :28.. Where is this 28 Rows.. i don't now. Before i delete all rows there was it was say 19682 rows while when i run Select Coun(*) The r...more >>

I have a text field in a txt file. It has multi-line. Id like to copy / paste this text in a SQL Server table field. I guess the field must be of a Text Data Type. I tried it and it retains only the first line. How can I paste that multimeline text from the SQL Server tools? I tried from...more >>

Hello, After you execute a query and get the results in the Results pane, how do you hide the results and message pane? ...more >>

Hello, I created some query files using NotePad, but they don't show up in the Solution Explorer for that project in SS2K5. And I was unable to figure out how to refresh the Solution Explorer. Any suggestion would be appreciated. -- Thanks in advance, Steven ...more >>

I created a recurring backup using the procedure below, but I can not find a way to modify the schedule. Please help. Thanks in advance Microsoft SQL Enterprise Manager Version 8 Instructions: How to create a database backup (Enterprise Manager) To create a database backup Expand ...more >>

Hello, I've a problem, When I Execute the following COMMAND in a batch command(.bat) NET STOP MSSQLSERVER NET START MSSQLSERVER MY_DATABASE APPLICATION I GOT Login failed for user 'XXX\Administrator' Exception, but when after the SERVER started long time, MY_DATABASE APPLICATION will not g...more >>

Hi I have restored a database to the same instance as it was backup, but as a copy of the original database (I need a couple of Stored Procedures), but while restoring the database is to hanging with (Loading). I've tried to drop the database but it says that it cannot be dropped because...more >>