Search results for query: *

Hi, In the event that the server that hosts replication goes down and then comes back up - do the replication jobs start automatically? Or say, the SQL Server Agent is stopped and started for any reason? Do the replication jobs re-start? I can't remember. So, my question is, do I need to...

in SQL Server 2005 why is it I am constantly discovering annoying lack of features in 2005 - that is, things that used to work perfectly fine in 2000 suddenly have no functionality in 2005 take import, for instance - you can no longer import to an existing table... you get an error... so each...

Hi, I have a developer here, that when she logs into and creates tables in the database, the owner of the table is her login, not dbo. How can I change the settings so that the tables she creates belongs to dbo instead? Or alternatively, she needs to be able to run: execute...

Hi, I would like to grant VIEW stored procedure permissions to a user in the database. I would like the user to see ALL the stored procedures in the database, just not change them in any way. So far I have determined I can use this stmt to accomplish this task: GRANT VIEW DEFINITION ON...

Hi, I have a database user with read-only permissions in the database. The user would like to be able to display a list of stored procedures in the database. I would like to grant this user the permission to do this, but without granting permission to *change* the sp's in any way. Is there a...

Hi, Using SQL Server 2005 Standard Edition, sp1 Here is my problem. When I try to use "SQL Server Configuration Manager" on the active node of a 2-server cluster to change the service accounts, I get the following error: "specified network password is not correct" I am trying to change the...

Hi, This is a topic that I've researched and researched and still can't find a decent answer to. That is, what permissions are needed for the SQL Server and SQL Server Agent accounts?? To make things more complicated, we are running a 2005 cluster. However, I am assuming you change the service...

Am I the only person who finds BOL's syntax diagrams undecipherable??? What am I doing wrong here?? ARgggghhhhh ALTER TABLE myTable ADD myForeignKeyName FOREIGN KEY (column name) REFERENCES PKTable (column name)

Hi, I used the ALTER TABLE command to disable some indexes on a table. Now, of course, I can't find the command to ENABLE the indexes! My other question is - will disabling the indexes make data loads faster? That is what I need. Seems easier than dropping/recreating the indexes. Can someone...

I have about 20 tables. I need to create DROP and CREATE statements for all Primary Keys, Foreign Keys, and Indexes on the table. I would like a script that can do this in one handy step. Using the EM scripting, I can only do CREATE statements, not the drop statements. I've searched all over...

Hi, I have about 20 tables that I need to script indexes. That is, for each table, I'd like to have DROP and CREATE statements for all the indexes on the table, including primary keys. Does anyone have a script that can do this quickly and painlessly? THANKS much

Question: are linked servers needed in order to use replication? Thanks

This keeps showing up as an "application name" in profiler. Microsoft (r) Windows Script Host But what is it? Thank you

Hi, I need to write a query that will go through an entire table containing data spanning several months, if not years. What I need to do is a count of the "number of leads" per week for the given time span (months or years). I know from having done a similar query that looks at the previous...

Hi, I have a situation that is driving me crazy. We have a zillion (it seems) logins/users in our databases, and I know that not all of them are in use. I need to find out which ones are actually in use and which ones aren't. These were created long before I came on board, and it's a mess. I...

Hi, What are the steps for making a production database, one that has live clients connected to it, read-only? It's okay if we disconnect clients... but I want to make sure it's done properly. Thank you

Hi, I am posting this problem again... I restored some databases last week. All the databases are fully online, and query-able. I am trying to set up jobs to create backups to a network share. Problem is, when I try to back up I get this error msg: Executed as user: domain\domainuser. The...

Is there a way to filter a trace by DATABASE?? Thanks

SQL Server 2005 - backing up to a network share Has anyone seen this error message when performing a backup? The backup of the file or filegroup "sysft_Articles" is not permitted because it is not online. There is a table in this database called "Articles". I can query from the table, but...

Hi, This is related to my other thread. I have worked through the problem some more. I granted connect to guest in the database that has the tables referenced by the view. Now, I am getting error: Microsoft OLE DB Provider for ODBC Drivers error '80040e09' [Microsoft][ODBC SQL Server...