Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
Grant using Query
Posted by Steven K0 at 2/18/2006 11:40:22 PM
I am using the following to create the text for granting permissions to
SELECT 'GRANT EXECUTE ON '+ name + ' TO Web_Publish'
FROM sysobjects WHERE (type = 'P') AND (category = 0) AND (name LIKE
Is it possible to actually grant permissions ...more >>
Problems with sp_droplogin in SQL 2005
Posted by Gaetan Simard at 2/18/2006 8:56:02 PM
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 >>
Posted by Jishnu at 2/18/2006 7:07:26 PM
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
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 >>
alter table inside a stored procedure
Posted by dcruncher4 NO[at]SPAM aim.com at 2/18/2006 5:00:08 PM
Our application needs to issue an alter table statement. Since the user
the application does not have dbo permission, we are planning to use
a stored procedure with dynamic sql.
SET @RUNSQL = "alter table dbo.gggg .."
The stored procedure is owned by dbo. However...more >>
Posted by Maya at 2/18/2006 4:43:57 PM
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 >>
Wrong Rows count
Posted by Islamegy® at 2/18/2006 4:26:41 PM
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
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 >>
HELP: Text Field data type in SQL Server
Posted by Progman at 2/18/2006 2:11:07 PM
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 >>
Hide Results Pane after executing query
Posted by Steven K0 at 2/18/2006 1:29:32 PM
After you execute a query and get the results in the Results pane, how do
you hide the results and message pane?
Don't see what you're looking for? Search DevelopmentNow.com.
Solution Explorer: Showing Query Files
Posted by Steven K0 at 2/18/2006 11:13:53 AM
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,
Edit MSSQL scheduled backup
Posted by Candee at 2/18/2006 4:50:26 AM
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
How to create a database backup (Enterprise Manager)
To create a database backup
Expand ...more >>
ISSUE: After the SQL Server restart, Login failed for user 'XXX\Administrator'
Posted by zzppallas at 2/18/2006 12:57:15 AM
I've a problem, When I Execute the following COMMAND in a batch
NET STOP MSSQLSERVER
NET START MSSQLSERVER
I GOT Login failed for user 'XXX\Administrator' Exception, but when
after the SERVER started long time, MY_DATABASE APPLICATION will not
Cannot drop database (hanging in loading and marked for replication)
Posted by Kim at 2/18/2006 12:00:00 AM
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